TonyM
11 years agoOccasional Contributor
Cannot write to Excel properly.
Hello, My function for writing to excel is not working properly. It will write some data in the beginning of the file, but doesn't seem to write anything beyond row 20 or column N. Some...
- 11 years agoHi M R, I tried the following calls to your function for an empty xlsx document multiple times and they worked fine every time:
var fileName = "C:\\Temp\\testwrite.xlsx";
writeToXL( fileName, "Sheet1", 2, 2, "test" );
writeToXL( fileName, "Sheet1", 30, 30, "test" );
writeToXL( fileName, "Sheet1", 30, "n", "test" );
writeToXL( fileName, "Sheet1", 30, "AA", "test" );
Could there perhaps be something configured in the document you are trying to write to that might prevent this from working?
Regards,
Phil Baird