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.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
He tried to convert Excel sheets to images and had some problems.
1) Some portion of the sheet was not converted or (deleted)
2) Korean characters were not converted and cracked.
3) 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.