pcsoft.us.windevCopyright 2026, PC SOFT1 Jun 2015 18:36:00 Z1 Jun 2015 09:07:00 ZHi As usual I am trying things way pass my skill set. I want to use Gembox Spreadsheet for spreadsheet creation on a web server and specifically Pivot Tables. I have imported the .NET assembly and have managed the following 4 lines of code which does work although my data is imported into Sheet 1 and 'NewSheet' is never created. ef is ExcelFile ef.Worksheets.Add("NewSheet") ef.LoadCsv("C:\My Sites\PlumAccounting\Exe\PlumAccounting_NOB97010\0\ActualvsBudget.csv",",") ef.save("C:\My Sites\PlumAccounting\Exe\PlumAccounting_NOB97010\0\Test.xlsx") According to Gembox sample code something like this should be used to access a worksheet and data table: C# ExcelWorksheet ws = ef.Worksheets.Add("NewSheet"); DataTable dt = new DataTable(); The problem is to reference ExcelWorksheet, or in fact any of the other methods in the .NET assembly besides ExcelFile. I have tried this ew is ExcelWorksheetCollection = ef.Worksheets.Add("NewSheet") ew is ExcelWorksheet = ef.Worksheets[1] which does not work. The error I get is Wrong parameter for constructor of ExcelWorksheet class. Can anybody please shed some light on this? Thanks in advance Ericus Steyn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52450/read.awp1 Jun 2015 18:36:00 ZYes Fabrice and if I knew how to do all that there would have been no need to post the message in the first place. Regards …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52450/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52450/read.awp[WD19] and Gemboxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52448/read.awp1 Jun 2015 16:35:00 ZHi Ericus, well, consideriung that yo are adding a second sheet into EW, while everything else is done on EF, and considering…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52448/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52448/read.awp[WD19] and Gemboxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52446/read.awp1 Jun 2015 15:24:00 ZHi Fabrice This code is working - sort of. It opens an existing spreadsheet and imports the CSV file which is a good start. B…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52446/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52446/read.awp[WD19] and Gemboxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52444/read.awp1 Jun 2015 14:12:00 ZHi Ericus, I have been working with the gembox document assembly, not the spreadsheet on (for now), but I'l give it a try …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52444/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52440-wd19-and-gembox-52444/read.awp[WD19] and Gembox