Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Mar 19, 2015 7:16 pm

Hi,

The DSUM function does not seem to be supported, is it something that will be added in the future. We have an excel file that uses it a lot, making it impossible to use your API for us.

Thank you!

carlvaillancourt
 
Posts: 5
Joined: Wed Mar 18, 2015 8:19 pm

Fri Mar 20, 2015 6:48 am

Hello,

Thanks for your inquiry.

Spire.XLS supports DSUM function, while Free Spire.XLS doesn't support it. Please download Spire.XLS via link below and have a try:
http://www.e-iceblue.com/Download/download-excel-for-net-now.html

And here is the sample code
Code: Select all
 Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"test.xlsx");
            Worksheet wsSheet = workbook.Worksheets[0];       
            string currentFormula = "=DSUM(A1:C9,3,D1:D2)";
            wsSheet.Range["D4"].Formula = currentFormula;
            workbook.CalculateAllValue();       
            wsSheet.Range["D4"].Text = wsSheet.Range["D4"].FormulaValue.ToString();
            workbook.SaveToFile("Sample.xlsx");
            System.Diagnostics.Process.Start("Sample.xlsx");


Best Regards,
Sweety
E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Fri Mar 20, 2015 4:19 pm

Yes it is working now.

Thank you very much

carlvaillancourt
 
Posts: 5
Joined: Wed Mar 18, 2015 8:19 pm

Thu Mar 26, 2015 3:55 am

Hello,

Please feel free to contact us, if you have any questions or needs. We are here for help.

Sincerely,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS