StarDesktop.loadComponentFromURL -> Import WK1 Daten

[Hugo53]

Hallo,
ich möchte eine WK1 - Datei per Makro einlesen, kenne aber nicht den "Filternamen".
Für Excel funktioniert das Beispiel, aber welcher Wert wird für WK1 benötigt?

sub ImportExcel2000Dat
Dim arg(0) as new com.sun.star.beans.PropertyValue
Dim sURL as String
Dim oDoc
arg(0).name = "FilterName"
arg(0).value = "Microsoft Excel 97/2000/XP"
sURL = "file:///d:/tmp/ExcelBeispiel.xls"
oDoc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, arg())
end sub

sub ImportWK1Dat
Dim arg(0) as new com.sun.star.beans.PropertyValue
Dim sURL as String
Dim oDoc
arg(0).name = "FilterName"
arg(0).value = "????????"
sURL = "file:///d:/tmp/WK1_Beispiel.WK1"
oDoc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, arg())
end sub

[Toxitom]

Hey Hugo,

...aber welcher Wert wird für WK1 benötigt?

Ist eine Lotus 1-2-3 Datei?

Dann propier mal die folgenden Begriffe:

Lokalisierter Filtername: "Lotus 1-2-3"
interner Filtername: "Lotus"

Eigentlich sollten beide funktionieren, also teste einfach mal.

Gruss
Thomas

[Hugo53]

Hallo Thomas,
leider führen die beiden Werte für den "FilterName" nicht zum Erfolg.

sub ImportExcel2000Dat
Dim arg(0) as new com.sun.star.beans.PropertyValue
Dim sURL as String
Dim oDoc
arg(0).value = "Microsoft Excel 97/2000/XP"
arg(0).name = "FilterName"
sURL = "file:///d:/tmp/ExcelBeispiel.xls"
oDoc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, arg())
' -> ok
arg(0).name = "FilterName"
arg(0).value = "Lotus 1-2-3"
sURL = "file:///d:/tmp/WK1_Beispiel.WK1"
oDoc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, arg())
' -> nicht erfolgreich
arg(0).name = "FilterName"
arg(0).value = "Lotus"
sURL = "file:///d:/tmp/WK1_Beispiel.WK1"
oDoc = StarDesktop.loadComponentFromURL(sURL, "_blank", 0, arg())
' -> nicht erfolgreich
end sub

Gruss Horst

[Stephan]

Ich bin im Moment etwas irritiert das Dein Excel-Beispiel funktioniert, aber hier ist eine Auflistung aller Filter für OpenOffice.org:


Filternamen für OpenOffice.org 1.1.x-Versionen

Ami Pro 1.x-3.1 (W4W)
BMP - MS Windows
CGM - Computer Graphics Metafile
DIF
DXF - AutoCAD Interchange
EMF - MS Windows Metafile
EPS - Encapsulated PostScript
GIF - Graphics Interchange
HTML
HTML (StarCalc)
HTML (StarWriter)
JPG - JPEG
Lotus
Lotus 1-2-3 1.0 (DOS) (StarWriter)
Lotus 1-2-3 1.0 (WIN) (StarWriter)
MET - OS/2 Metafile
MS Excel 4.0
MS Excel 4.0 (StarWriter)
MS Excel 4.0 Vorlage/Template
MS Excel 5.0 (StarWriter)
MS Excel 5.0/95
MS Excel 5.0/95 Vorlage/Template
MS Excel 95
MS Excel 95 (StarWriter)
MS Excel 95 Vorlage/Template
MS Excel 97
MS Excel 97 Vorlage/Template
MS PowerPoint 97
MS PowerPoint 97 Vorlage
MS WinWord 5
MS WinWord 6.0
MS Word 6.x (W4W)
MS Word 95
MS Word 95 Vorlage
MS Word 97
MS Word 97 Vorlage
MathML XML (Math)
MathType 3.x
PBM - Portable Bitmap
PCT - Mac Pict
PCX - Zsoft Paintbrush
PGM - Portable Graymap
PNG - Portable Network Graphic
PPM - Portable Pixelmap
PSD - Adobe Photoshop
RAS - Sun Rasterfile
Rich Text Format
Rich Text Format (StarCalc)
SGF - StarOffice Writer SGF
SGV - StarDraw 2.0
SVM - StarView Metafile
SYLK
StarCalc 1.0
StarCalc 3.0
StarCalc 3.0 Vorlage/Template
StarCalc 4.0
StarCalc 4.0 Vorlage/Template
StarCalc 5.0
StarCalc 5.0 Vorlage/Template
StarChart 3.0
StarChart 4.0
StarChart 5.0
StarDraw 3.0
StarDraw 3.0 (StarImpress)
StarDraw 3.0 Vorlage
StarDraw 3.0 Vorlage (StarImpress)
StarDraw 5.0
StarDraw 5.0 (StarImpress)
StarDraw 5.0 Vorlage
StarDraw 5.0 Vorlage (StarImpress)
StarImpress 4.0
StarImpress 4.0 Vorlage
StarImpress 5.0
StarImpress 5.0 (packed)
StarImpress 5.0 Vorlage
StarMath 2.0
StarMath 3.0
StarMath 4.0
StarMath 5.0
StarOffice XML (Calc)
StarOffice XML (Chart)
StarOffice XML (Draw)
StarOffice XML (Impress)
StarOffice XML (Math)
StarOffice XML (Writer)
StarWriter 1.0
StarWriter 2.0
StarWriter 3.0
StarWriter 3.0 (StarWriter/GlobalDocument)
StarWriter 3.0 (StarWriter/Web)
StarWriter 3.0 Vorlage/Template
StarWriter 4.0
StarWriter 4.0 (StarWriter/GlobalDocument)
StarWriter 4.0 (StarWriter/Web)
StarWriter 4.0 Vorlage/Template
StarWriter 4.0/GlobalDocument
StarWriter 5.0
StarWriter 5.0 (StarWriter/GlobalDocument)
StarWriter 5.0 (StarWriter/Web)
StarWriter 5.0 Vorlage/Template
StarWriter 5.0/GlobalDocument
StarWriter DOS
StarWriter/Web 4.0 Vorlage/Template
StarWriter/Web 5.0 Vorlage/Template
TGA - Truevision TARGA
TIF - Tag Image File
Text
Text (StarWriter/Web)
Text (encoded)
Text (encoded) (StarWriter/GlobalDocument)
Text (encoded) (StarWriter/Web)
Text - txt - csv (StarCalc)
WMF - MS Windows Metafile
XBM - X-Consortium
XPM
bmp_Export
bmp_Import
calc_HTML_WebQuery
calc_StarOffice_XML_Calc_Template
calc_pdf_Export
dBase
draw_PCD_Photo_CD_Base
draw_PCD_Photo_CD_Base16
draw_PCD_Photo_CD_Base4
draw_StarOffice_XML_Draw_Template
draw_bmp_Export
draw_emf_Export
draw_eps_Export
draw_flash_Export
draw_gif_Export
draw_html_Export
draw_jpg_Export
draw_met_Export
draw_pbm_Export
draw_pct_Export
draw_pdf_Export
draw_pgm_Export
draw_png_Export
draw_ppm_Export
draw_ras_Export
draw_svg_Export
draw_svm_Export
draw_tif_Export
draw_wmf_Export
draw_xpm_Export
dxf_Import
emf_Export
emf_Import
eps_Export
eps_Import
gif_Export
gif_Import
impress_StarOffice_XML_Draw
impress_StarOffice_XML_Impress_Template
impress_bmp_Export
impress_emf_Export
impress_eps_Export
impress_flash_Export
impress_gif_Export
impress_html_Export
impress_jpg_Export
impress_met_Export
impress_pbm_Export
impress_pct_Export
impress_pdf_Export
impress_pgm_Export
impress_png_Export
impress_ppm_Export
impress_ras_Export
impress_svg_Export
impress_svm_Export
impress_tif_Export
impress_wmf_Export
impress_xpm_Export
jpg_Export
jpg_Import
math_pdf_Export
met_Export
met_Import
pbm_Export
pbm_Import
pcd_Import_Base
pcd_Import_Base16
pcd_Import_Base4
pct_Export
pct_Import
pcx_Import
pgm_Export
pgm_Import
placeware_Export
png_Export
png_Import
ppm_Export
ppm_Import
psd_Import
ras_Export
ras_Import
sgf_Import
sgv_Import
svg_Export
svm_Export
svm_Import
tga_Import
tif_Export
tif_Import
wmf_Export
wmf_Import
writer_JustSystem_Ichitaro_10
writer_JustSystem_Ichitaro_10_template
writer_MIZI_Hwp_97
writer_StarOffice_XML_Writer_Template
writer_WPSSystem_WPS2000_10
writer_globaldocument_StarOffice_XML_Writer
writer_globaldocument_StarOffice_XML_Writer_GlobalDocument
writer_globaldocument_pdf_Export
writer_pdf_Export
writer_web_HTML_help
writer_web_StarOffice_XML_Writer
writer_web_StarOffice_XML_Writer_Web_Template
writer_web_pdf_Export
xbm_Import
xpm_Export
xpm_Import


Filternamen für OpenOffice.org 2.0/2.0.1

StarOffice XML (Writer)
PSD - Adobe Photoshop
calc_HTML_WebQuery
draw_png_Export
StarWriter 4.0
calc_StarOffice_XML_Calc_Template
StarOffice XML (Calc)
draw_jpg_Export
writer_globaldocument_StarOffice_XML_Writer_GlobalDocument
HTML (StarWriter)
StarWriter 3.0 Vorlage/Template
StarWriter 4.0 Vorlage/Template
StarWriter 5.0 Vorlage/Template
WMF - MS Windows Metafile
Text (encoded) (StarWriter/GlobalDocument)
writer_JustSystem_Ichitaro_10
writer_web_HTML_help
DIF
HTML
draw_ppm_Export
StarDraw 3.0 Vorlage (StarImpress)
StarDraw 5.0 Vorlage (StarImpress)
MS Word 95 Vorlage
MS Word 97 Vorlage
MS PowerPoint 97 Vorlage
draw8
MS Excel 97 Vorlage/Template
RAS - Sun Rasterfile
HTML (StarCalc)
writer_StarOffice_XML_Writer_Template
chart8
draw_wmf_Export
StarMath 3.0
writer_WPSSystem_WPS2000_10
XPM
SGV - StarDraw 2.0
StarChart 4.0
writer8
draw_pgm_Export
MS Word 2003 XML
StarMath 5.0
EMF - MS Windows Metafile
draw_tif_Export
MS Excel 5.0/95
draw_pbm_Export
MS Excel 95 (StarWriter)
StarWriter 3.0 (StarWriter/Web)
StarWriter 4.0 (StarWriter/Web)
StarWriter 5.0 (StarWriter/Web)
MS Excel 95
StarCalc 4.0
MS Excel 97
draw_emf_Export
Lotus 1-2-3 1.0 (WIN) (StarWriter)
SVM - StarView Metafile
impress_StarOffice_XML_Impress_Template
StarImpress 5.0
Lotus 1-2-3 1.0 (DOS) (StarWriter)
SGF - StarOffice Writer SGF
StarWriter 3.0 (StarWriter/GlobalDocument)
StarWriter 4.0 (StarWriter/GlobalDocument)
StarWriter 5.0 (StarWriter/GlobalDocument)
StarOffice XML (Math)
WordPerfect
JPG - JPEG
PocketWord File
StarWriter/Web 4.0 Vorlage/Template
draw_xpm_Export
draw8_template
MS Excel 4.0 Vorlage/Template
StarWriter/Web 5.0 Vorlage/Template
Text (StarWriter/Web)
calc8_template
draw_bmp_Export
draw_PCD_Photo_CD_Base4
calc8
draw_flash_Export
Text - txt - csv (StarCalc)
MathType 3.x
PPM - Portable Pixelmap
StarImpress 5.0 (packed)
writerglobal8
Rich Text Format
StarDraw 5.0 (StarImpress)
StarOffice XML (Base)
StarWriter 1.0
writer_pdf_Export
Rich Text Format (StarCalc)
impress8
impress_bmp_Export
impress_emf_Export
impress_eps_Export
impress_gif_Export
impress_jpg_Export
impress_met_Export
impress_pbm_Export
impress_pct_Export
impress_pdf_Export
impress_pgm_Export
impress_png_Export
impress_ppm_Export
impress_ras_Export
impress_svg_Export
impress_svm_Export
impress_tif_Export
impress_wmf_Export
impress_xpm_Export
DXF - AutoCAD Interchange
StarCalc 3.0 Vorlage/Template
StarCalc 4.0 Vorlage/Template
StarCalc 5.0 Vorlage/Template
StarWriter 3.0
writer8_template
impress8_draw
AportisDoc Palm DB
placeware_Export
StarOffice XML (Draw)
impress_StarOffice_XML_Draw
StarWriter 5.0
MS WinWord 6.0
Pocket Excel
StarWriter DOS
Text (encoded)
writerglobal8_writer
MS Word 95
MS Word 97
TIF - Tag Image File
draw_pdf_Export
MS Excel 95 Vorlage/Template
writer_MIZI_Hwp_97
MS Excel 5.0 (StarWriter)
XHTML Impress File
PCX - Zsoft Paintbrush
impress_flash_Export
draw_gif_Export
dBase
draw_ras_Export
BMP - MS Windows
MS Excel 2003 XML
StarMath 2.0
StarChart 3.0
StarWriter 4.0/GlobalDocument
StarWriter 5.0/GlobalDocument
EPS - Encapsulated PostScript
StarMath 4.0
StarOffice XML (Chart)
XHTML Writer File
Text
writer_JustSystem_Ichitaro_10_template
XHTML Calc File
CGM - Computer Graphics Metafile
StarChart 5.0
math_pdf_Export
MS PowerPoint 97
XBM - X-Consortium
StarDraw 3.0 Vorlage
StarDraw 5.0 Vorlage
draw_html_Export
StarCalc 1.0
MS Excel 5.0/95 Vorlage/Template
draw_PCD_Photo_CD_Base16
draw_PCD_Photo_CD_Base
writer_web_pdf_Export
writer_web_StarOffice_XML_Writer_Web_Template
StarCalc 3.0
MathML XML (Math)
StarImpress 4.0
StarDraw 3.0
StarCalc 5.0
draw_pct_Export
PCT - Mac Pict
draw_met_Export
MS Excel 4.0
writerweb8_writer
StarDraw 5.0
XHTML Draw File
writer_globaldocument_pdf_Export
impress8_template
Lotus
MS Excel 4.0 (StarWriter)
TGA - Truevision TARGA
DocBook File
writerweb8_writer_template
GIF - Graphics Interchange
draw_eps_Export
Text (encoded) (StarWriter/Web)
writer_web_StarOffice_XML_Writer
calc_pdf_Export
MS WinWord 5
PGM - Portable Graymap
draw_svg_Export
StarImpress 4.0 Vorlage
StarImpress 5.0 Vorlage
SYLK
MET - OS/2 Metafile
PNG - Portable Network Graphic
draw_StarOffice_XML_Draw_Template
StarOffice XML (Impress)
StarDraw 3.0 (StarImpress)
writer_globaldocument_StarOffice_XML_Writer
PBM - Portable Bitmap
math8
draw_svm_Export
StarWriter 2.0
impress_html_Export



Gruß
Stephan