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
#57797 - 12/10/20 01:38 PM extract each tab from an xls file
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 400
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: 1984
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: 400
Loc: Home
thank you, I'll try DataBase plugin!
_________________________
Peace

Top