IMPORTANT ANNOUNCEMENT

These forums will be permanently set to read-only mode on July 18, 2022. From that day on, no new posting or comment will be allowed on the site, but the historical content will remain intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#57663 - 09/04/20 03:21 PM Convert xls data file to csv
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 400
Loc: Home
Hi,
Is there any script to convert an xls file to csv format?
Client sending xls files only!

thanks
_________________________
Peace

Top
#57664 - 09/08/20 08:26 AM Re: Convert xls data file to csv [Re: Sami786]
jim3108 Online   content
OL Expert

Registered: 04/19/10
Posts: 316
Loc: London, UK
You could use a Run Script to open the file in Excel in the background and save as a CSV.

Let me know if you need help doing this.

Regards,

James.

Top
#57803 - 12/11/20 09:50 AM Re: Convert xls data file to csv [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 400
Loc: Home
Hi Jim, Yes please send me the scrip to open file in Excel and then save it as CSV format, and also let me know if there's a way to save each tab separately. The other option is to use ODBC Excel Files driver!
_________________________
Peace

Top