Appending data to existing excel

(0) Share

Report

Posted on by Anoop B

Hi ,

I am trying to appending row data to a existing excel file via x++ code. While trying to append rows, the process is working fine but atlast the datas are not added to the excel. The iteration are executing correctly while debuging. But i think saving the file with memoryStream is happening some issue. Can anyone help me in this.

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Anoop, I am not sure but can you try moving package.Save() inside the loop before i++.

Check this article

www.d365snippets.com/.../how-to-create-and-export-excel-files-using-xpp-in-d365.html

Was this reply helpful? Yes No
Verified answer

Martin Dráb 238,534 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Will it change if you save it to another stream with SaveAs()?

using (System.IO.MemoryStream outputStream = new System.IO.MemoryStream()) { package.SaveAs(outputStream); File::SendFileToUser(outputStream, 'test.xlsx'); }

Was this reply helpful? Yes No
Anoop B 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin, Actually It worked

Was this reply helpful? Yes No