Copy 500 element array to Excel?

[Archie]

Where are you storing the file? Windows 10 may be more restrictive about writing to certain directories. If you are writing to the same directory as the executable by using ".\MyFile.xlsx", then it should work fine.

[bob1371]

I'm running the application off USB drive but storing file to C:\Data.
Changed it to write file to USB drive and working fine.

Thanks.

[Birdsill]

Hi Bob
I was wondering if you dabbled with the cell formatting yet? More towards converting the data type from text to number. 

[bob1371]

I just had it Autosize the width to fit the headers. As for converting to a number, the team that will be gathering this data for trending will just multiply by 1 when they do the import.


You might look at this and it may lead you in right direction.

worksheet.cells["C2:C5"].style.Numberformat.format = "#,###"

[Birdsill]

Thanks!