Hello Team,

I have two questions about XLS headers:

  1. May I export a grid without headers in an output file?
  2. Is it possible to skip header row during import of XLS file?

And one question about XLSX: do you have any plans about this filetype?

Best regards, Andrew

asked 21 Nov '13, 07:09

Andrew%20Pouckatch's gravatar image

Andrew Pouck...
1611
accept rate: 0%


Hi Andrew,

1- There is not a direct parameter in the API which can make you able to export without grid header but while generating the output file, Formspider takes the visible state of the grid header into consideration. If it's not visible, the generated output file does not contain header row. Therefore, as a workaround, you can set the grid header invisible just before the export and then make it back visible again just after the export like:

  api_component.setgridheadervisible('mainPanel.grid','N');
  api_component.printtoexcel('mainPanel.grid','N','XXX',api_datasource.FILE_FORMAT_XLS);
  api_component.setgridheadervisible('mainPanel.grid','Y');

We can add this option as a parameter to the API, I will create a ticket about this feature in our issue management system.

2- No, it's not possible to skip header row during import of XLS file. But I guess being able to export XLS file without header row may satisfy your need about this issue.

3- We don't have a plan for XLSX filetype for the near future but I will also create a ticket about this feature in our issue management system.

Best Regards,
Ibrahim

link

answered 21 Nov '13, 15:22

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Hi Ibrahim,

setGridHeaderVisible() works fine, thank you.

Unfortunatelly, we receive files from our customers in both XLS and XLSX formats with headers. So we have to pre-process them

(22 Nov '13, 03:07) Andrew Pouck...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×8
×3
×1

Asked: 21 Nov '13, 07:09

Seen: 1,075 times

Last updated: 22 Nov '13, 03:07


© Copyright Gerger 2017