Cells - > xlsx to csv to database

Aspose.Cells Product Family
1

We are able to use .cells to select a excel file from a local directory, manipulate the xlsx file columns and rows and then export as a clean csv. Using java, how can we now insert this csv into a sql database? Is this possible with .cells?
thanks

2

some more info we already have our xlsx in a sheet object that we delete columns and rows from, and line up to a database table. Just wondering if there is code to import directly to database from the sheet object

3

@jt10

Thanks for considering Aspose APIs.

We are afraid, this question is not related to Aspose.Cells. Aspose.Cells allows you to save Workbook object in byte array stream which can easily be converted to byte[].

Now you need a code to save byte[] into database e.g. SQL Server.

The following article explains how to save byte[] array into SQL Server using Java

Reference Internet Articles:

  • How to store/retrieve image to/from SQLServer
  • How to add byte array to database with JDBC?
4

Thanks we were able to do a batch insert into SQL once we got the worksheet in to a data table 2D array.

5

@jt10

Thanks for your feedback and using Aspose APIs.

It is good to know that your issue is resolved now. Let us know if you are still facing any issue or any other issue, we will be glad to look into it and help you further.