New

Complicated Excel file to be synced to a web page on an hourly basis.

Tuesday, November 22, 2016

3 Replies

2.2K Visits

Greetings, I have a complicated Excel file with multiple tabs. I have been asked to find a way to present this file within web pages. The file changes hourly in some cases. The pages do not have to be post-edited once they are synced but they do need to be continually synced once the edits have been made in Excel. Example: A user edits a file (presumably on the server or uploaded), then the component converts the file and shows up on a web page. Is this possible? Thanks in advance.

Assistance

8 years ago

#5482

Hi,

Thanks for contacting us here about this extension.
Yes, you can automatically synchronize with Google sheets in Droptables. For more details:
https://www.joomunited.com/documentation/droptables-documentation#toc-6-3-automatic-excel-and-google-sheets-sync

Thanks a lot!
Regards,

adarr

8 years ago

#5486

OK. Thanks.

How does it handle tabs/pages within an Excel file?

How does it handle formula data? Is this simply static data when it imports?

Does it import formatting such as cell colors?

This is something that we will most likely purchase anyway just to experiment with, but I would like to know as much as possible beforehand.

Thanks

Assistance

8 years ago

#5487

Hi,

Thanks for contacting us here about this extension.

How does it handle tabs/pages within an Excel file?

In fact, it can sync first sheet only.

How does it handle formula data? Is this simply static data when it imports?

Currently, the result will be sync when importing.

Does it import formatting such as cell colors?

Yes, it does. For more details: https://www.joomunited.com/documentation/droptables-documentation#toc-3-1-format

Regards,

Page :
1

There are no replies made for this post yet.