There is no direct way to accomplish your task. You have to use your own code to save to database/data source. Please note, Aspose.Cells for Java provides Cell.getHtmlString attribute which you may use to replace existing string by html string. See the sample code segment for your reference:
e.g. Sample code:
Workbook book = new Workbook("f:\\files\\Sample Excel.xlsx");
Worksheet sheet = book.getWorksheets().get(0);
Range range = sheet.getCells().getMaxDisplayRange();//You may also create your desired range (in the worksheet) using, e.g sheet.getCells().createRange("A2", "B3");
Iterator rangeIterator = range.iterator();
while(rangeIterator.hasNext())
{
Cell cell = (Cell)rangeIterator.next();
cell.putValue(cell.getHtmlString());
//your code goes here.
}
//your code goes here.
Next you may export the data in the sheet(s) to fill an array or data table, see the document on data exporting options for your reference.
Now you may use your own Java code to insert/fill this data (in array or data table) to database/data source for your needs.
But I am still not clear about how I am going to build a table. What I was looking for is an HTML string that will look alike the table in the excel.
I tried your code and saw HTML string getting created for each cell, but it is not anything related to HTML <TR> and <TD>.
So what I understand is that, I need to create a code where a table string will be created, and every cell’s html string needs to be appended to table string within TR and TD tags to form a complete table.
@ashish29190,
You may try the following sample code which converts a table from an Excel file into Html and saves it to a file. This information can be used to save the table as string in the database. Give it a try and share the feedback.
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);
// Adding sample values to cells
worksheet.getCells().get("A1").putValue(50);
worksheet.getCells().get("A2").putValue(100);
worksheet.getCells().get("A3").putValue(150);
worksheet.getCells().get("B1").putValue(60);
worksheet.getCells().get("B2").putValue(32);
worksheet.getCells().get("B3").putValue(50);
// Set the print area.
worksheet.getPageSetup().setPrintArea("A1:B3");
// Initialize HtmlSaveOptions
HtmlSaveOptions options = new HtmlSaveOptions();
// Set flag to export print area only
options.setExportPrintAreaOnly(true);
options.setExportGridLines(true);
//Save to HTML format
workbook.save("output.html", options);
The problem here is that the output html file generated contains commented code in the style tag. Though that part is commented, it works and attaches its style properties to the elements. Can we do anything in the aspose to change this thing.
PFA for the html file generated and Source Excel File.
@ashish29190,
I can not find the commented code about style tag in output.html file.
Could you please check the attachment created with Aspose.Cells for Java 20.12 and let us know your feedback. asposeissue.zip (7.4 KB)
@ashish29190,
We have further investigated the issue and would like to share that there is no other option available in Aspose.Cells which can be used to trim the undesired text from the Html file. However it is quite easy to extract pure table contents from the html file as follows:
private static void Cells_Html() throws Exception
{
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);
// Adding sample values to cells
worksheet.getCells().get("A1").putValue(50);
worksheet.getCells().get("A2").putValue(100);
worksheet.getCells().get("A3").putValue(150);
worksheet.getCells().get("B1").putValue(60);
worksheet.getCells().get("B2").putValue(32);
worksheet.getCells().get("B3").putValue(50);
// Set the print area.
worksheet.getPageSetup().setPrintArea("A1:B3");
HtmlSaveOptions options = new HtmlSaveOptions(SaveFormat.HTML);
options.setExportHiddenWorksheet(false);
options.setExportImagesAsBase64(true);
options.setExcludeUnusedStyles(true);
options.setExportComments(false);
options.setExportDocumentProperties(false);
options.setExportWorkbookProperties(false);
options.setExportWorksheetProperties(false);
options.setDisableDownlevelRevealedComments(true);
//Save to HTML format
workbook.save("output.html", options);
String data=readFile("output_files\\sheet001.htm",Charset.defaultCharset());
String result = "<table"+ StringUtils.substringBetween(data, "<table", "</table>")+ "</table>";
System.out.println(result);
}
static String readFile(String path, Charset encoding) throws IOException
{
byte[] encoded = Files.readAllBytes(Paths.get(path));
return new String(encoded, encoding);
}
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.