ONLYOFFICE Docs v6.4 with conditional formatting, new scaling options, and WOPI protocol support
ONLYOFFICE Docs v6.4 released

Import data from different spreadsheet files

Hello

I’m trying to find a way to import data from a spreadsheet that is in the nextcloud repository to another spreadsheet, is it possible to do this process?
Thank you very much in advance!

Hello tiago.

Unfortunately, there’s no such feature for your request.

Sorry for inconvenience.

Hello Alexander.

Correct, and you don’t have a forecast or interest in composing this function?

Thanks

Sorry, “Alexandre”

Could you please describe in detail the desired scenario of mentioned feature. How exactly do you imagine this process?

Hello Alexandre

As I use Onlyoffice integrated with Nextcloud, it may be possible to have this exchange of information between xlsx files, through its “link” url, being informed together with the cell where the data you want is located. It can also impose that acceptance is requested with an alert of the movement to the user, bringing an extra layer of security.

Grateful!

Hello tiago.
Thank you for detailed description. We thought about something similar. Unfortunately, I cannot provide you with any timeframes or in what form such functionality will be implemented.

But we are planning to implement the similar idea.

Hello Alexandre
Perfect, I’m available to help with anything that is relevant.

Att.te

1 Like

Hi there, this is a feature I’m also desperately searching for. It’s esp. lacking when you want to move your system from GSuite to ONLYOFFICE.

IMPORTRANGE

Google Sheets has a very good way to import a range from another spreadsheet.
Maybe this can be some inspiration. spreadsheet_url could be a link to another ONLYOFFICE file.

IMPORTRANGE(spreadsheet_url, range_string)

EXAMPLE

IMPORTRANGE("https://docs.google.com/spreadsheets/d/1Hh2grfB6rp9OQ2yAIu3S5YF_CCFJGwyqPGveABlOZKg/edit", "World Cup!A1:D21")

ABOUT
Imports a range of cells from a specified spreadsheet.

spreadsheet_url
The URL of the spreadsheet from which data will be imported.

range_string
A string of the format “[sheet_name!]range” (e.g. “Sheet1!A2:B6” or “A2:B6”) specifying the range to import.

Further Import functions

There is also a number of other import functions as can be seen in the picture below. All doing essentially the same thing but are different in the way they consume the data.