File input from Excel workbooks

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
DFH
Posts: 976
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

File input from Excel workbooks

Post by DFH »

Suggested enhancement to the GUI for the file input filter:

When an input file is an Excel workbook, provide a tick box option to Ignore hidden worksheets.

Another related idea: Provide a tick box option to choose Treat each worksheet as a separate input file.
Each inputFilename for this option would need to be derived from the worksheet name.

I have assumed that for multiple worksheets, the way TextPipe currently works would be to process all the sheets into the same output stream.
I have not tested that this is the case. The help file makes no reference to multiple worksheets in an Excel file. Please clarify.

Best regards,

David
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: File input from Excel workbooks

Post by DataMystic Support »

TextPipe adds a form feed between each sheet in the output file.

For now, I am playing with the filter skipping hidden (and very hidden) sheets. I will look into it more tomorrow.
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
DFH
Posts: 976
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: File input from Excel workbooks

Post by DFH »

Another two suggestion:
  • Provide a tick box option to get cell contents as formulae rather than as values.
    Provide a tick box option to get cell comments as well, ideally suitably tagged.
David
Post Reply