Does somebody knows how to read Excell table by ACL code? I need to read an Excell table which is looking as Illustrated Part Catalog, that is it contains rows with cells: callout_number, number_part, name_part, quantity.
Firstly task is looked simple: I saved Excell like csv file and then read lines of csv file as text file by ACL code. But some cells of origin Excell table containes few lines of text in one cell: 2 or 3 or even 4 lines of text, which have been separated by new lineseparator. In such case a string of csv file is interrupted in the separator place and it begins from new line. Structure of csv file becomes complex.
So Ibelieve it is more easy torecognize Excell.
Thanks in advance, if help is possible.
Thanks for all who responded.
I went by simplest way and process csv fileby acl code. (I analise all interruptions and variants in csv and acl code delivers correct table)
Probably I will try to create rev 2 with using com object, as Clay suggested.