Question

Null Values in Excel Writer

N

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

2 replies

xiaomengatsafe
Rank
Badge +2
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
Rank
Badge +2

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

Reply


Community Stats

28,654
Posts
109,294
Replies
36,528
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.