Hi :) Sorry i can't help with Macros and sorry no-one else has been able to reply yet! The best i can do is to point to documentation and hope something in there helps. First Chapter 13 of the "Getting Started" guide https://wiki.documentfoundation.org/Documentation/Publications Then Andrew Pitonyak's guide https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers
Regards from Tom :) On 25 February 2014 15:57, HP4 <[email protected]> wrote: > Hi, > I can't find any information on how to set the arguments for > "LoadComponentFromURL" when loading a csv-file via macro over the network. > The example below worked fine with OpenOffice some time ago, but yields > exceptions when running it with LibreOffice because the function call > returns a NULL pointer. So my question: > > - where can I find a list of valid filters for LibreOffice? > - what arguments do I have to provide to read csv-files? > > The available documentation in the API on how to supply these arguments is > useless when it doesn't provide the allowed values or a hint how to > construct them. Also I couldn't find any helpful information via Google. > > BR > HP > -------------------------------------------------------------------- > Sub Main > Dim loadArgs2(1) as New com.sun.star.beans.PropertyValue > > lurl = "http://domain.org/file.csv"; > lsfo = "44/32,34,ANSI,2," > > loadArgs2(0).Name = "FilterName" > loadArgs2(0).Value = "Text - txt - csv (StarCalc)" > loadArgs2(1).Name = "FilterOptions" > loadArgs2(1).Value = lsfo > > lDoc = StarDesktop.LoadComponentFromURL(lurl,"_blank",0,loadArgs2()) > lSheet = lDoc.Sheets().getByIndex(0) > End Sub > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
