File input from Excel workbooks

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

DFH
Posts: 658
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

File input from Excel workbooks

Postby DFH » Fri Mar 28, 2014 1:19 am

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: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: File input from Excel workbooks

Postby DataMystic Support » Tue Apr 29, 2014 4:36 pm

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, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

DFH
Posts: 658
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: File input from Excel workbooks

Postby DFH » Fri May 02, 2014 10:00 pm

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


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest