Maybe someone has already worked with this problem and can suggest a solution?
My Code on C#, but it doesn't matter:
Code: Select all
var ooType = Type.GetTypeFromProgID("com.sun.star.ServiceManager");
var ooApp = Activator.CreateInstance(ooType);
var desktop = ooApp.Invoke("createInstance", BindingFlags.InvokeMethod, new Object[1] { "com.sun.star.frame.Desktop" });
var driverManager = ooApp.Invoke("createInstance", BindingFlags.InvokeMethod, new Object[1] { "com.sun.star.sdbc.DriverManager" });
var sURL = "sdbc:odbc:PostgreSQL35W";
var oCon = driverManager.Invoke("getConnection", BindingFlags.InvokeMethod, new Object[1] { sURL });
var oStatement = oCon.Invoke("CreateStatement", BindingFlags.InvokeMethod);
var sSQL = "SELECT * FROM \"myTable\"";
var oResult = oStatement.Invoke("executeQuery", BindingFlags.InvokeMethod, new Object[1] { sSQL });
Code: Select all
var pars = new Object[4] { "private:factory/scalc", "_blank", 0, new Object[] { hidden } };
var workBook = desktop.Invoke("loadComponentFromUrl", BindingFlags.InvokeMethod, pars);
var sheets = workBook.Invoke("getSheets");
var sheet = sheets.Invoke("getByIndex", par: new Object[] { 0 });
var pivotTables = sheet.Invoke("getDataPilotTables");
var pivotsDesc = pivotTables.Invoke("createDataPilotDescriptor");
I find only Method pivotsDescriptor.SetRange("A1:A10') but can't find method SetQuery or SetQueryResult or smth like this?