Hi
I want to load two files into the same clac file, with two sheets
sUrl = convertToUrl("C:\Users\File1.txt")
sSheetName = "File1"
Dim FileProperties(1) As New com.sun.star.beans.PropertyValue
FileProperties(0).Name = "FilterName"
FileProperties(0).Value ="Text - txt - csv (StarCalc)"
FileProperties(1).Name = "FilterOptions"
'FileProperties(1).Value = "FIX,,0,1,0/2/10/36/19/4"
FileProperties(1).Value = "9,34,ANSI,1,1/2/2/2/3/1/4/1"
oCSV = StarDesktop.loadComponentFromURL( sUrl, "_blank", 0, FileProperties())
oSourceSheet = oCSV.Sheets( 0 )
osourcesheet.name=sSheetName
sUrl = convertToUrl("C:\Users\File2.txt")
sSheetName = "File2"
Dim FileProperties(1) As New com.sun.star.beans.PropertyValue
FileProperties(0).Name = "FilterName"
FileProperties(0).Value ="Text - txt - csv (StarCalc)"
FileProperties(1).Name = "FilterOptions"
'FileProperties(1).Value = "FIX,,0,1,0/2/10/36/19/4"
FileProperties(1).Value = "9,34,ANSI,1,1/2/2/2/3/1/4/1"
oCSV = StarDesktop.loadComponentFromURL( sUrl, "_blank", 0, FileProperties())
oSourceSheet = oCSV.Sheets( 0 )
osourcesheet.name=sSheetName
But it open two calc files insted of one calc file with two sheets
Pleace help