Re: [libreoffice-users] opening file via macro failes

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 <hp4everything@googlemail.com> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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