pcsoft.us.windevCopyright 2026, PC SOFT5 Jun 2015 16:14:00 Z2 Jun 2015 10:01:00 ZI am making progress with accessing the Gembox features but the problem I have is to access a specific worksheet, a specific row or specific cells. I have the following with my comments on what is working ef is "GemBox.Spreadsheet.ExcelFile" //This loads an existing empty xlsx file ef <- ExcelFile.Load("C:\My Sites\PlumAccounting\Exe\PlumAccounting_NOB97010\0\Test.xlsx") //This loads the data into Sheet 1 of the above file ef.LoadCsv("C:\My Sites\PlumAccounting\Exe\PlumAccounting_NOB97010\0\ActualvsBudget.csv",",") //This supposedly adds another sheet to the existing spreadsheet //If I return ef.worksheets.count it returns 2 so I think it is working ef.Worksheets.Add("Sheet2") //Now I want to ensure that I am working with the newly added worksheet so according to the Gembox documentation the recently added sheet becomes the ActiveWorksheet //The code below is not giving an error and is supposed to 'load' the active worksheet. ew is ExcelWorksheet <- ef.Worksheets.ActiveWorksheet //However now I want to work with one row on this worksheet //The line below is accepted er is ExcelRow <-ew.Rows //but if I want to change the details of 1 row there is no way I can do that //this gives an error that er is a COLLECTION of rows (ExcelRowCollection). I want to work with 1 row er.Style.Font.Weight = ExcelFont.BoldWeight //I have tried various ways to refer to a single row i.e. er[1].Style.Font.Weight = ExcelFont.BoldWeight er(1).Style.Font.Weight = ExcelFont.BoldWeight //I have tried this to indicate that I am only working with Row 1. Although the code does not give an error at execution you get message that you cannot access a sub-element er is ExcelRow <-ew.Rows[1] Is there anybody that can help please? Thanks in advance. Ericus Steyn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52568/read.awp5 Jun 2015 16:14:00 ZYes Alexander the interface everything is there. For instance: //other stuff before this ef is ExcelFile dynamic = new Ex…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52568/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52568/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52567/read.awp5 Jun 2015 14:29:00 ZHi Ericus, Has WD created an interface with functions like get_ExcelWorksheetCollection( n ) or something in the like? I reme…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52567/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52567/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52565/read.awp5 Jun 2015 11:27:00 ZThanks Jose Array is just one way I tried to access a single worksheet or cell. In windev you either get a syntax error on…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52565/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52565/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52564/read.awp5 Jun 2015 11:13:00 ZHi. In the windev help says that arrays of objects are not supported. I also tried yesterday some basic example and could not …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52564/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52564/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52563/read.awp5 Jun 2015 10:31:00 ZHi Al You are right about Gembox support. Been dealing with a Mario there and he tried as best he could. For anybody else int…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52563/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52563/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52559/read.awp5 Jun 2015 00:36:00 ZHello Ericus You might also try talking to Gembox. From personal experience with their MS Word product, their level of suppo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52559/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52559/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52556/read.awp4 Jun 2015 21:13:00 ZThanks Yogi I have followed the examples closely and the C# ones are very close to the syntax in Windev. It is to point to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52556/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52556/read.awp[WD19] and Gembox - Another attemptguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52553/read.awp4 Jun 2015 17:23:00 ZPlease check the .NET samples for GemBox and then try to do the same in WD. Yogi Yanghttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52553/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52466-wd19-and-gembox-another-attempt-52553/read.awp[WD19] and Gembox - Another attempt