I work in retail. For promo sales we're given a spreadsheet with data containing the information about the product and its prices. With this data we're supposed to create sale tags. More specifically, the data to be displayed includes the product name, short description, sale price, normal price, amount saved, etc.
Is there a programmatic way I can convert this spreadsheet data to a nice sale tag in one click? Here are some rough ideas of mine:
- PHP image generation of a html page which is then converted to PDF (since I know PHP)
- Somehow link google spreadsheets (or MS excel) with google docs (or MS word) for document generation
I'd rather but am not restricted to a web-based solution. Otherwise, I'm open to the quickest/easiest method to get this done.