Pricing

Rating

Developer

Actor stats

Categories

Share

🖨️ — Cost Sheet Generator

Cloud-native version of the Art Pro Sublimation desktop cost sheet tool. Provide image URLs, set your rate, and get back a branded Excel invoice — ready to download and print on A4.

How It Works

1. You provide a list of image URLs (print-ready files)
2. The actor downloads each image, reads its pixel dimensions and DPI
3. It parses the filename to extract quantity and description
4. It calculates area (sqft) and cost at your specified rate
5. It generates a branded .xlsx invoice with the full Art Pro layout
6. The Excel file is stored in the Key-Value Store with a direct download URL

Filename Convention

Images should follow this naming pattern for automatic parsing:

{number}{separator}{quantity}{description}.ext

Input Example

{
"images":[
{"url":"https://example.com/1-2_LargeBanner.jpg"},
{"url":"https://example.com/2-1_SmallPoster.png","filename":"2-1 Small Poster.png"},
{"url":"https://example.com/3-5_FlexBoard.tif"}
],
"rate":35,
"invoiceNo":"INV-0042",
"customerName":"Ali Traders",
"folderName":"March Batch",
"designer":"Usman",
"comments":"Urgent delivery",
"printType":"CHINA/NORMAL/FLU",
"logoUrl":"https://example.com/logo.jpeg",
"outputFilename":"cost_sheet.xlsx"
}

Output

1. Excel Cost Sheet (.xlsx)

Stored in the Key-Value Store. The direct download URL is included in both the actor logs and the dataset output, e.g.:

https://api.apify.com/v2/key-value-stores/{id}/records/cost_sheet.xlsx

The Excel file features:

• Yellow / Blue / Orange branded accent stripes
• Black header band with company name and contact
• Rate and QR area in the header
• Invoice metadata (number, customer, designer, comments)
• 10-column data table (S No, QTY, Description, W×L, T/F, Price, Amount)
• Alternating row shading
• Auto multi-sheet (new sheet every 35 items, continuous numbering)
• Grand totals in PKR
• Fit-to-page A4 print layout

2. Structured JSON Summary

Pushed to the Dataset output:

• download_url — direct link to the Excel file
• total_sqft, total_cost_pkr — grand totals
• line_items[] — per-image breakdown (dimensions, DPI, cost)
• skipped[] — any images that failed with error details

Configuration

License

ISC