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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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