Exporting to Excel - Table (keep formatting in place)

More
2 years 1 month ago - 2 years 1 month ago #23792 by prashant
Hellos, 
I am moving chat to forums from email as requested. 

This is my LOOM video explaining 

I am attaching the Output excel, ATS file  and CSV file here as well. 
 

File Attachment:

File Name: HR1Merged.zip
File Size:12 KB

 
Last edit: 2 years 1 month ago by prashant.
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #23795 by admin
Thank you for the clarification

I understand the issue and what is required  from us.

Basically excel has Sheets, Named Ranges and Tables.

What you are trying to do is to add data to a Table which is not supported yet.

Also data reader only works correctly with sheets but not ranges or tables.

It is technically possible to implement what is required but it will take some time 

The good thing that it will also benefit existing users. 

 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #23866 by admin
Just letting you know that we have made some progress and still working on adding support for tables.


Mike
ETL Architect
The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #23876 by prashant
This one would be a fun release , many things supported by excel on it's api

1. one sheet can have multiple table as well (side by side), imagine the template . 
2. tables have option to "clear" / append , so you can either add to table range or restart from fresh 
 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #23887 by Peter.Jonson
FYI. Support for reading data from excel tables and updating them was introduced in the latest release
Any problems let us know  

A lot of our users use our software to automate working with excel so it is extremely important that it works correctly.
 

Peter Jonson
ETL Developer
The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

More
2 years 1 month ago #23919 by prashant
Hi,
I am able to select the tables , see the list in dropdown .

Can we write to the tables yet? IF yes , which options do I select ?

 

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save