Spread 导出Excel

收藏

Spread 怎样将“自定义的函数”计算后的结果导出Excel，而不是把对应的函数导出Excel后无法计算值的问题。（说明：我这里的函数需要从数据库中抓取数据，而导出Excel 后，其函数也导出了，但是无法计算值，导致很多列没有值，显示“#NAME?”）,请各位大侠江湖救急。
我的要求就是把公式计算的结果导出。

roger.wang · roger.wang

回复 1楼supper3000的帖子

ExcelSaveFlags.DataOnly，这个试过没有？

FpSpread1.SaveExcel("C:\\fp.xls", FarPoint.Excel.ExcelSaveFlags.DataOnly)

复制代码

supper3000 · supper3000

回复 2楼roger.wang的帖子

您好，导出后，没有样式了，请问还有其它方法吗？

roger.wang · roger.wang

回复 3楼supper3000的帖子

ExcelSaveFlags 有很多值可选的，即enum之间可实现或 |的
如NoFlagsSet | NoFormulas .

// Summary:
// Specifies what part of the spreadsheet to export to an Excel-compatible file.
[Flags]
public enum ExcelSaveFlags
{
// Summary:
// [0] Saves the spreadsheet to the Excel-compatible file with no special options.
NoFlagsSet = 0,
//
// Summary:
// [1] Saves the displayed data but not the formulas to the Excel-compatible
// file.
NoFormulas = 1,
//
// Summary:
// [2] Saves the custom row headers to the Excel-compatible file.
SaveCustomRowHeaders = 2,
//
// Summary:
// [4] Saves the custom column headers to the Excel-compatible file.
SaveCustomColumnHeaders = 4,
//
// Summary:
// [6] Saves both the custom row headers and the custom column headers to the
// Excel-compatible file.
SaveBothCustomRowAndColumnHeaders = 6,
//
// Summary:
// [8] Saves the results of rows after filtering them to the Excel-compatible
// file.
SaveAsFiltered = 8,
//
// Summary:
// [16] Saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.
UseOOXMLFormat = 16,
//
// Summary:
// [32] Saves only the data to the Excel-compatible file.
DataOnly = 32,
//
// Summary:
// [64] Saves the appearance settings of alternating rows to the Excel-compatible
// file.
SaveAlternatingRowStyles = 64,
//
// Summary:
// [136] Saves the spreadsheet as viewed to the Excel-compatible file.
SaveAsViewed = 136,
//
// Summary:
// [256] Uses a custom color palette, and uses it for color approximations if
// there are more than 56 colors set into Spread.
UseCustomPaletteForColorApproximations = 256,
//
// Summary:
// [512] Uses the default color palette.
UseDefaultColorPalette = 512,
//
// Summary:
// [1024] Saves the displayed data and formatting, but not the notes.
NoNotes = 1024,
//
// Summary:
// [2048] Keeps Excel data that was previously loaded from the files (e.g. VBA,
// Macro).
DocumentCaching = 2048,
//
// Summary:
// [4096] The default row height is not saved. Excel will automatically determine
// row heights based on the largest font that is set in each row.
AutoRowHeight = 4096,
//
// Summary:
// [8192] Saves the displayed data in the combobox celltype, does not save the
// items in the combo box.
ComboDataOnly = 8192,
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] Spread 导出Excel

3 个回复

活字格认证

微信认证勋章

元老葡萄