I have a question from our customer who has been using your trail version of
“Aspose cells for Java” before his actual purchase, and he like to know a couple of
things which he need to know for sure.
He tried to convert Excel sheets to images and had some problems.
-
Some portion of the sheet was not converted or (deleted)
-
Korean characters were not converted and cracked.
-
lines from tables and borders are not showing.
He likes to know the way way to solve ;
i) not showing Korean font problems
ii) Lines and borders shows as they should.
I have attached his captured images for you to take a look.
What he was trying to do was read excel files from the server directory and
save selected sheets to images back to the server directory.
Testing Environment;
-
Programs are in Java
-
Weblogic 10
-
Unix based
-
Web based system
-
Added 5 jar files to the web application lib
aspose-cells-2.5.2-java\JDK 5.0\aspose-cells-2.5.2-java\lib
aspose-cells-2.5.2.jar
dom4j-1.6.1.jar
jsr173_1.0_api.jar
stax2-api-3.0.2.jar
woodstox-core-asl-4.0.8.jar
Did some test like below and confirmed that image files are generated in Server Directory.
import com.aspose.cells.*;
// Instantiate a new workbook
Workbook book = new Workbook();
// Open an existing file
String excel_file = UPLOAD_DIR + "/" + cuid+".xls";
book.open(excel_file);
// Create an object for ImageOptions
ImageOptions imgOptions = new ImageOptions();
// Set the format type of the image
imgOptions.setImageFormat(ImageFormat.PNG);
// Get the first worksheet.
Worksheet sheet = book.getWorksheets().getSheet(0);
// Create a SheetRender object with respect to your desired sheet
SheetRender sr = new SheetRender(sheet, imgOptions);
String image_file = UPLOAD_DIR + "/" + cuid;
for (int j = 0; j < sr.getPageCount(); j++)
{
//Generate image(s) for the worksheet
sr.toImage(j, image_file+"_" + j + ".png");
}
This customer is very important to us and I hope
if you can tell us how to approach this customer.