Importing Text Files

Feb 16, 2016 at 7:34 PM
Edited Nov 9, 2016 at 9:15 PM

UPDATE 2016-11-09:

No suggestions? Really? How about a tutorial on using Workbooks.Open or similar? Is there really no mechanism in NetOffice for importing a delimited text file and processing it similar to a VBA macro?

We use a lot of VBA macros on a server which manipulate various text files we receive every night. Mostly they create spreadsheets and add data to Access databases.

We'd like to move away from having MS Office installed on the server, of course, but can't do that unless we can find a substitute which can manipulate the text file data we receive.

I've used ClosedXML and SpreadsheetLight libraries, but they produce an XLSX file, and many of our existing tools (like other macros and databases) look for the XLS files, so NetOffice seemed like a great choice.

I can't find any documentation on opening a text file (the files have no file extension, just the file name like DLYBCKLG vs. DLYBCKLG.TXT) into Excel and manipulating it, or importing the data into a spreadsheet. Is this functionality possible with NetOffice?

We'd love to use this product because it handles both versions of Excel files, and the coding is similar to VBA (brilliant!), but we need to be able to open those nightly files and save them in XLS format.

Is this possible? If so is there an example somewhere I can look at or download? I couldn't find anything on the web.