We are looking for a way to manipulate xlsx files from our Ruby web application. There are some ruby libraries (gems) for this, but they are all very rudimentary.
My question is:
Say we have a spreadsheet that acts as a data table with 5 columns X 20 rows, with a Total row at the bottom containing SUMs for each column.
Can I use the ASPOSE API to insert 3 new rows of data into that spreadsheet, and have the SUM formulas at the bottom get updated automatically, as they would if I’d simply pasted new rows while working in Excel? The libraries I’ve looked in the Ruby world can insert the data OK, however they don’t automatically update any formulas that are affected by the insert.
Thanks for your inquiry. Currently, you can insert empty rows or copy existing rows. In order to achieve your goal you can then update cell values. You also need to send another REST API call to calculate the SUM in the last row. So it is a workaround. I have logged a new feature request to insert rows with data. This feature has been logged under ticket id SAASCELLS-56 in our issue tracking system. Your request has also been linked to this issue and you will be notified as soon as it is resolved and available for the public use. We’re sorry for your inconvenience.
I’m sorry to share with you that the required ruby examples are not available at the moment. I’ve logged a task to provide you the required example topics. This task has been logged under ticket id SUPPORT-1304 in our issue tracking system. Anyways, you can also prepare these REST API calls.
Please visit the API pages here:
I hope, this helps. Please let me know in case of any confusion or questions.
It is to update you that we have added the required Ruby examples so far we are closing the task logged under ticket id SUPPORT-1304. Please take a look over following example topics:
Please do let me know in case of further assistance or questions.