Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel Expoting Issue

Hi All,

I am facing one issue into send to excel data.

where if my No of rows are more that 65 K approx  then it will stores the data into sheet1 and remaining data are getting store into sheet2.

but i want to make it into sheet 1 only however the data will be.

Do i need to do some modification or changes on some server settings or into Application.

please help.

thanks in advanced.

Alok Kumar

Labels (2)
9 Replies
Not applicable
Author

Hi Kumar,

In Microsoft office 2003,

Open workbooks

Limited by available memory and system resources

Worksheet size

65,536 rows by 256 columns

But Microsoft office 2010,

Worksheet size

1,048,576 rows by 16,384 columns

which version you are using?

Not applicable
Author

Thanks Kumar,

I am using Microsoft office 2010 & QlikView 11.2. SR 2.

Do i have to do some changes to get into One sheet.

Not applicable
Author

Hi Alok,

Due to the row limit in excel, it can't handle more than 65,000 records in one sheet. You can try exporting in CSV by using export option. There is no row limit in CSV file.

Regards,

Sankalp

Not applicable
Author

Thank you sankalp,

do i have to do any changes ???

if so what are the changes i have to make??

Not applicable
Author

No changes are required, just right click and use export option.

Not applicable
Author

This properties does not exist into AJAX Mode. 

Not applicable
Author

You need to right click on the chart/table box and use export option.

Please refer the screenshot, property do exist.

Untitled.png

Not applicable
Author

Hi Sankalp,

Thanks for your response, but in my Case I am not getting all this options.

PFA of Screenshot.

I think i have do some changes to get this option.

Not applicable
Author

Hi Kumar,

I am trying CSV file, there is no limit into CSV file.