Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to write an exact cell of an Excel sheet?

Hello everyone,

I would like to write a string in an exact cell of an existing Excel file.

 

For example, I would like to write "Week" in the cell 9L. 

 

Is it possible to do? 

 

I  unsuccessfully tried using tRowGenerator and tFileOutputExcel.

 

Any suggestions?

 

Thank you in advance.

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello,


@Jack1618 wrote:

Hello everyone,

I would like to write a string in an exact cell of an existing Excel file.

 

For example, I would like to write "Week" in the cell 9L. 

 

Is it possible to do? 

 

I  unsuccessfully tried using tRowGenerator and tFileOutputExcel.

 

Any suggestions?

 

Thank you in advance.

 

 

 


What does your actual result look like when use tRowGenerator-->tfileoutputexcel?

Best regards

Sabrina

 

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hello,


@Jack1618 wrote:

Hello everyone,

I would like to write a string in an exact cell of an existing Excel file.

 

For example, I would like to write "Week" in the cell 9L. 

 

Is it possible to do? 

 

I  unsuccessfully tried using tRowGenerator and tFileOutputExcel.

 

Any suggestions?

 

Thank you in advance.

 

 

 


What does your actual result look like when use tRowGenerator-->tfileoutputexcel?

Best regards

Sabrina

 

Anonymous
Not applicable
Author

Hello and thanks for the answer.

 

I learned that tRowGenerator has "Number of Rows for RowGenerator" param, and that's what I needed.

 

So my problem is solved.

 

Thank for the reply,

 

Jack

Anonymous
Not applicable
Author

Hello Jack,

Thanks for posting that your issue has been fixed.

Best regards

Sabrina