Topic Options
#29760 - 11/26/08 11:37 AM Excel spreadsheet as datastream
-nth- Offline
OL Expert

Registered: 04/01/03
Posts: 236
Loc: Lincoln, NE
It would be nice to see PlanetPress add Excel spreadsheets (xls, xlsx) as a supported data type. It's often easy to convert to CSV, but every once in a while it's not. A similar design to PrintShop Mail's Excel feature would be great.


#29761 - 11/26/08 02:13 PM Re: Excel spreadsheet as datastream
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4954
Loc: Objectif Lune Montreal
Indeed it would be nice if we could just drop-down an xls file as data stream!

However, there is already a way to use Excel files. You can connect to Excel files using database inputs and calling ODBC. You can then setup an ODBC connection that will point to an Excel file, and connect to that ODBC datasource. You'll be able to use the Excel file as the data this way. It's not as convenient as just dropping a CSV in a folder input, but it will work fine.