Free Support Forum - aspose.com

Problem using Smart Markers

Hi,

I am trying to use smart markers in excel to populate the spread sheet with values from a database and the java snippet is like:

ResultSet r =s.executeQuery(“SELECT EmpNumber as Emp FROM model.dbo.EmployeeDetails”);
WorkbookDesigner designer = new WorkbookDesigner();
designer.open(“C:\ExcelTemplate.xls”);
designer.setDataSource®;
designer.process(0,false);
designer.clearDataSource();
designer.save(“C:\WithSmartMarkers.xls”);

Is this the correct way to use? I’m not able to get any values in the target xls though the file is being generated. I’m attaching the source template and target files along with the exception details. Please let me know the mistake.

Thanks.

Hi,

The problem got resolved when the result set is made scrollable and insensitive.

Thanks