Topic Options
#57797 - 12/10/20 01:38 PM extract each tab from an xls file
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 393
Loc: Home
Hi team,

Client can only sent us xls file with additional 20 tabs data.

I need to extract each tab separately and save them as CSV format. Like CSV_Tab1.csv, CSV_Tab2.csv, .... and CSV_Tab20.csv

How do I go about this via workflow, any idea?

Thanks
_________________________
Peace

Top
#57800 - 12/11/20 08:20 AM Re: extract each tab from an xls file [Re: Sami786]
Philippe F. Offline
OL Expert

Registered: 09/06/00
Posts: 1969
Loc: Objectif Lune, Montreal, Qc
There's no native functionality that allows you to do that in Workflow.

One thing you could try, though, is using the Database plugin to read the file using the ODBC Excel Files driver. With that driver, the XLS is considered a database and each tab is a table. You can then extract each table separately and save them as independent CSVs.
_________________________
Technical Product Manager
I don't want to achieve immortality through my work; I want to achieve immortality through not dying - Woody Allen

Top
#57802 - 12/11/20 09:39 AM Re: extract each tab from an xls file [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 393
Loc: Home
thank you, I'll try DataBase plugin!
_________________________
Peace

Top