Hi,
I'd like to convert a VBScript app that I wrote, which imports a tab-delimited file into Excel, and performs all sorts of formatting functions.
I used the B4J Excel library - forgot what it was called - sometime back. No problem with that.
My question is how should I approach the import? Just create a spreadsheet, parse out each line from the tsv file, and proceed from there?
The VBScript is working perfectly, and has been in production for almost a year. The problem is that it has a dependence on Excel itself being present, and I'd like to generate the excel file without that requirement.
My only question is the Import part of the equation.
I'd like to convert a VBScript app that I wrote, which imports a tab-delimited file into Excel, and performs all sorts of formatting functions.
I used the B4J Excel library - forgot what it was called - sometime back. No problem with that.
My question is how should I approach the import? Just create a spreadsheet, parse out each line from the tsv file, and proceed from there?
The VBScript is working perfectly, and has been in production for almost a year. The problem is that it has a dependence on Excel itself being present, and I'd like to generate the excel file without that requirement.
My only question is the Import part of the equation.