Nav 5
I've seen various postings reading importing from Excel via automation but nothing which answers my problem.
While importing excel files using the standard excel buffer table and functions you will occasionaly get an error because a cell contains a long text (more than 250 chars).
I was investigation a solution but haven't gotten anywhere. What I'd like to do is to use the Excel vba functions on the cell contents before importing. Something along the lines of:
xlapp.vbafunctioncalls.len(XlWrkSht.Range(xlColID + xlRowID))
the idea being that the evaluation of the length of the cell be done in excel and the result returned, rather than nav extracting the contents of the cell and then passing it back to excel to calculate the length.
There is an evaluate function which can be passed a string to be evaluated but it involves jumping through hoops to construct a cell reference in text format.
Anyone done any work on this?
Ian
Comments
Go to:
Table 370, function "ReadSheet"
and change line with
Hope this is what You were trying to do.
In the end I solved this by writing a small tool for excel which simply scanned each cell of a file before importing and chopped the length. I also extended slightly the size of the import buffer. The user has to click on a 'check' button in excel before importing but its simple and works - which is what the user wants in any case.
Thanks for the suggestion anyway.
Ian