将报告导出为ex​​cel和excel应该为报告的sum字段创建公式字段 [英] export report to excel and excel should create formula fields for the sum fields of the report

问题描述

当我将报告导出到excel并且我的报告中有sum字段时，我希望excel将字段创建为公式字段，我可以操作excel中的数据，值将会波动到sum字段。



这可能吗？



提前致谢

解决方案

可以这样做，但你需要做一些工作。



1.如果你有预定义的Excel表格，你可以使用OleDbConnection

如何使用C＃中的OleDbConnection将数据插入到Excel 2007中[ ^ ]



2.如果你想从头开始创建所有东西，我会调查这个网站。

excellibrary



使用ExcelLibrary对Excel文件转换进行Excel文件转换 [ ^ ]



我希望这可以帮助你前进。 / BLOCKQUOTE>

When I export a report to excel and my report has sum fields, I would like excel to create the fields into formula fields that I could manipulate the data in excel and the values will ripple thru to the sum fields.

Is this possible?

Thanks in advance

解决方案

It is possible to do, but you need to do some work.

1. If you have a pre-defined Excel sheet with formulas you can use OleDbConnection
How to insert data into excel 2007 using OleDbConnection in C#[^]

2. If you want to create everything from scratch, I would look into this site.
excellibrary

DataSet to Excel File Conversion using ExcelLibrary[^]

I hope this helps you forward.

这篇关于将报告导出为ex​​cel和excel应该为报告的sum字段创建公式字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！