Topic Options
#56833 - 03/11/19 02:45 PM Pull data from different tab
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
Hi OL team, I have an xls data file with 3 tabs. Each tab has specific static info that I need to print on the page.
Is it possible to pull data from different tabs?
So far I'm using Load External File to read data, and I can read tab A and using ExpandString function. But how can I read data from Tab B and C to print on the page?

THANKS


Edited by Sami786 (03/11/19 02:47 PM)
_________________________
Peace

Top
#56834 - 03/11/19 02:54 PM Re: Pull data from different tab [Re: Sami786]
jouberto Offline
OL Toddler

Registered: 04/18/18
Posts: 32
Hi Sami,

You will have no choice but to pre-process all 3 tabs individually and "store" their info in a common resource to be able to use all 3 tabs to populate a single page. You cannot pull from multiple sources at once. If you already were able to extract the info from 1 tab, you can reproduce what you did for the other 2 tabs, 1 by 1, and have the data written to a common text file, a variable, or even update your own single tab spreadsheet with the info from the other sheets and then connect to that one when producing output.

Thanks. Regards,

Top
#56836 - 03/12/19 09:39 AM Re: Pull data from different tab [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
Thank you Jouberto, I guess I should first manually save each tab as a CSV file, then process them individually, just wanted to bypass the manual work, I'll Google if I can find a third party to save each tab in a csv files.

THANKS
_________________________
Peace

Top
#56837 - 03/12/19 10:37 AM Re: Pull data from different tab [Re: Sami786]
jouberto Offline
OL Toddler

Registered: 04/18/18
Posts: 32
Hi Sami,

If you have Workflow you can automate all this instead. Since you are planning on using CSV format, you could simply use 3 PlanetPress Database plugins that return a csv, and do a send to folder with the concatenation option, on the same target file. this will have your 3 tabs "exported" into 1 csv(given that the header names are the same)

Top
#56838 - 03/12/19 04:05 PM Re: Pull data from different tab [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
but I still have to manually split the 3 tabs, workflow will not split them for me!
_________________________
Peace

Top
#56839 - 03/12/19 05:10 PM Re: Pull data from different tab [Re: Sami786]
jouberto Offline
OL Toddler

Registered: 04/18/18
Posts: 32
Hi Sami,

Each db connexion will look at a different tab, you don't have to split them. When setting up your connexion, you choose a file, and a tab. Do 3 different connexions, each on their own tab.

Regards,

Top
#56853 - 03/18/19 09:16 AM Re: Pull data from different tab [Re: Sami786]
Sami786 Offline
OL Expert

Registered: 01/29/14
Posts: 324
Loc: Home
Jouberto, I'm still confused, I'm using a xls file that I need to convert to CSV, this is not a bd connection?
_________________________
Peace

Top