Doubt in usage of Aspose.Cells

Aspose.Cells Product Family
1

Hi,

I am using Aspose.cells in my application and i face the totaling issue. I have referred to your earlier posts for solving this issue however it is still persisting. I am attaching my excel sheet along with the code snippet. Please have a look and let me know if i need to change anything with my code.

2

Hi,

Please find the excel sheet attached here.

Thanks and Regards,

Divya

3

Hi Divya,

Our forums don't allow to post txt file to avoid malicious code. Could you please zip and post your code here? Thank you very much.

By the way, you can try this attached fix first to see if it solves your problem.

4

Hi Divya,

Both template file and codes are fine.

But your forget to set the datasource "CONVENTION_LEVEL" . And you can use WorkbookDesigner.Open method to replace WorkbookDesigner.Workbook.Open method to open the file.

5

Hi Warren,

Merry Christmas to you.

Thanks for your time and support. I added the snippet as suggested by you.

Please find two excel sheets and the code (in word document) attached. One excel sheet is the template(cms_Budget_rpt) and other is the output (OUTPUT_cmsBudget_rpt) that is generated. I have added comment for the line in ehich i am facing the error.

Thanks for kind helpand support.

Regards,

Divya Dixit

6

I am attaching the template with this post

7

With this post i am attaching the output that is generated

Thanks and Regards,
Divya Dixit

8

Hi,

If the field’s value is null, please do not use “” as value of the cell.

See following codes:

If (oRsData.Fields("next_budget") <> Null) Or (oRsData.Fields("next_budget") <> "NULL") Then

If (IsNumeric(oRsData.Fields("next_budget"))) Then

arr2(i)= CInt(oRsData.Fields("next_budget"))

Else

arr2(i) = oRsData.fields("next_budget")

End If

End if
9

Hi,

The error still persists. Any other solution that you can help with.

Thanks and Regards,

Divya Dixit

10

Hi,

Please post your changed codes and created xls file. We will check it soon.

11

Hi,

Please find the changed ASP code in the attachment.

Thanks and Regards,

Divya Dixit

12

Hi,

Please find the generated xls file in this attachment.

Thanks and Regards,
Divya Dixit

13

Hi,

I’m not v family with VB. You have to assign null as the value.


If (oRsData.Fields("next_budget") <> Null) Or (oRsData.Fields("next_budget") <> "Null")

Or (oRsData.Fields("next_budget") <> "")

Then

If (IsNumeric(oRsData.Fields("next_budget"))) Then

arr2(i)= CInt(oRsData.Fields("next_budget"))

Else

arr2(i) = oRsData.fields("next_budget")

End If

End if

If you still get the error, please you print your result value of “next_budget” to html page with Response.Write and post them.