Hi Charles, *, On Mon, Mar 11, 2013 at 3:55 PM, Charles Jenkins <cejw...@gmail.com> wrote:
> dim dummy() ' Empty array of parameters > > starDesktop = createUnoService("com.sun.star.frame.Desktop") > url = ConvertToUrl( ExcelPath ) > doc = starDesktop.loadComponentFromURL( url, "_blank", 0, dummy ) > >> I think I need what is described in >> http://knowledgebase.progress.com/articles/Article/P147655 -- an extension >> that can wrap strings into the property values required by >> loadComponentFromUrl(), so I can fill the array of parameters in a way that >> tells LO it will be loading the text file into a spreadsheet. The "extension" just is a helper function for pretty-printing, you surely don't need that, but can enter the values right away. Dim args() as new com.sun.star.beans.PropertyValue args(0).Name = "FilterName" args(0).Value = "Text - txt - csv (StarCalc)" args(1).Name = "FilterOptions" args(1).Value = "<yourfilteroptionsstring>" http://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options#Filter_Options_for_the_CSV_Filter HTH, ciao Christian -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted