Forum Discussion

TonyM's avatar
TonyM
Occasional Contributor
10 years ago
Solved

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...
  • Philip_Baird's avatar
    Philip_Baird
    10 years ago
    Hi 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

Philip_Baird's avatar
Philip_Baird
Community Expert
10 years ago
Hi 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