How to open an other sheet (result of request) in the same excel file

Aspose.Cells Product Family
1

Hi all,

I have a question I open my Excel file with one sheet and I want to know
how to add an other sheet in the same Excel file.This second and third sheet will
be the result of a Sql request.

Ex : in my firm we use Aspose 2.5.0 because we have this license, I can use Aspose 2.5.3 with the same license?

thanks for your answer

2

Hi,


Please find below a link to technical article on Management of Worksheets. That also include a topic on “How to add a worksheet in same workbook”.
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/printing-workbooks.html

Below is a link to an article on Importing Data to worksheet,
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/importing-data-to-worksheets.html

Hope it helped. Please feel free to write back. Thank you

3

Hello babar.raza

Thanks for your answer, but I think there is a mistake about the first link because it’s explaining how to print one sheet.For my part, I want to add 3 or 4 worksheets in the same Workbook.

Thanks

4

Hi,


Sorry for inconvenience, Yes you are right, first link is not correct. Below is the correct link,
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/managing-worksheets.html

For the other problem with importing data. We will get back to you with a solution on this.

5

Hi,

The acceptable object type in the collection please refer to javadoc of Cell.setValue(Object). User custom classes cannot be assigned to cell directly.