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
