hibrid0 Active Member Licensed User Longtime User Jun 13, 2015 #1 Hi, I have a excel book and I can read, that's very easy. Now I try to write some cells. I follow the tutorial and samples here. With this code I can create a new Workbook from the original workbook. Code: Copy libro2.Initialize2(ruta_completa, "WORK.xls", libro1) respuestas_hoja=libro2.AddSheet("0-Preguntas", 0) celda.InitializeText(2, 2, "Hola Excel") respuestas_hoja.AddCell(celda) But this code create a new Sheet and write the cell, but with only that cell, no have the other sheet info, and I dont need create a sheet, in theory is copied from the original.
Hi, I have a excel book and I can read, that's very easy. Now I try to write some cells. I follow the tutorial and samples here. With this code I can create a new Workbook from the original workbook. Code: Copy libro2.Initialize2(ruta_completa, "WORK.xls", libro1) respuestas_hoja=libro2.AddSheet("0-Preguntas", 0) celda.InitializeText(2, 2, "Hola Excel") respuestas_hoja.AddCell(celda) But this code create a new Sheet and write the cell, but with only that cell, no have the other sheet info, and I dont need create a sheet, in theory is copied from the original.
hibrid0 Active Member Licensed User Longtime User Jun 13, 2015 #2 Problem solved I see the WritetableBook GetSheet. Code: Copy libro2.Initialize2(ruta_completa, "WORK.xls", libro1) respuestas_hoja=libro2.GetSheet(0) celda.InitializeText(2, 2, "Hola Excel") respuestas_hoja.AddCell(celda) Very easy, sorry. Upvote 0
Problem solved I see the WritetableBook GetSheet. Code: Copy libro2.Initialize2(ruta_completa, "WORK.xls", libro1) respuestas_hoja=libro2.GetSheet(0) celda.InitializeText(2, 2, "Hola Excel") respuestas_hoja.AddCell(celda) Very easy, sorry.