Skip to main content
Question

Null Values in Excel Writer

  • July 23, 2018
  • 2 replies
  • 73 views

I am creating an excel output with two sheets. I am using an excel template to populate relevant date to the sheet. All data being written to the excel (total of records 656), sheet 1 has relevant 299 records inserted (rows from 1 to 300) however sheet 2 has its data being written on the row 555 (the rows of 0 to 554 are empty). The start row in both sheets is set to 1 but this not being pick up by the sheet 2.

 

Not too sure what I am doing wrong here, any help would be much appreciated.

Thank you,

Natalia

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

xiaomengatsafe
Safer
Forum|alt.badge.img+11
Hi @nataliakaszkowi, I think it might help the community better understand the issue, and provide suggestions, if you could share your workspace, and the Excel template you are using on the writer. Thank you!

 


pratap
Contributor
Forum|alt.badge.img+12
  • Contributor
  • July 24, 2018

Hi,

Yes, As @XiaomengAtSafe told, it is better if we have workspace to understand how you are migrating the data to writers.

I suggest to check whether you are passing xlsx_row_id attribute to writer (which should not present)

Hope this helps

Pratap