Create an Excel link to LibreOffice

Creating a macro - Writing a Script - Using the API

Create an Excel link to LibreOffice

Postby Math » Mon Sep 02, 2019 6:03 pm

greetings friends ,

I have a difficult task that I have not been able to perform, I have done a lot of research, but I have not found a solution, so I come here in the forum to ask friends for help .

I need to create Links between an Excel spreadsheet and a libreoffice spreadsheet that is located in another directory .

To summarize my problem, I need to import data that is in a libreoffice spreadsheet, and I need to import the data into an Excel spreadsheet .

but since I will need to update this data daily in excel, so I need to create an Excel Link formula for libreoffice, because libreoffice data will change daily, so I need Excel to read this data that has changed and update itself .

remember that the two spreadsheets are in different directories .

thank you in advance for all the help .
LibreOffice 5.4.4.2 on Windows 7
Math
 
Posts: 89
Joined: Mon Oct 29, 2018 6:32 pm

Re: Create an Excel link to LibreOffice

Postby Bidouille » Wed Sep 04, 2019 9:47 am

User avatar
Bidouille
Volunteer
 
Posts: 285
Joined: Mon Nov 19, 2007 10:58 am
Location: France

Re: Create an Excel link to LibreOffice

Postby Math » Thu Sep 05, 2019 5:55 am

greetings Bidouille,
thank you very much for indicating Link . :super:

I will leave the topic open for possible new suggestions . :)
LibreOffice 5.4.4.2 on Windows 7
Math
 
Posts: 89
Joined: Mon Oct 29, 2018 6:32 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 10 guests