Spread 导出Excel

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

回复 1楼supper3000的帖子

ExcelSaveFlags.DataOnly， 这个试过没有？

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

复制代码

回复 2楼roger.wang的帖子

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

回复 3楼supper3000的帖子

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

1. 
   
2.     // Summary:
   
3.     //     Specifies what part of the spreadsheet to export to an Excel-compatible file.
   
4.     [Flags]
   
5.     public enum ExcelSaveFlags
   
6.     {
   
7.         // Summary:
   
8.         //     [0] Saves the spreadsheet to the Excel-compatible file with no special options.
   
9.         NoFlagsSet = 0,
   
10.         //
    
11.         // Summary:
    
12.         //     [1] Saves the displayed data but not the formulas to the Excel-compatible
    
13.         //     file.
    
14.         NoFormulas = 1,
    
15.         //
    
16.         // Summary:
    
17.         //     [2] Saves the custom row headers to the Excel-compatible file.
    
18.         SaveCustomRowHeaders = 2,
    
19.         //
    
20.         // Summary:
    
21.         //     [4] Saves the custom column headers to the Excel-compatible file.
    
22.         SaveCustomColumnHeaders = 4,
    
23.         //
    
24.         // Summary:
    
25.         //     [6] Saves both the custom row headers and the custom column headers to the
    
26.         //     Excel-compatible file.
    
27.         SaveBothCustomRowAndColumnHeaders = 6,
    
28.         //
    
29.         // Summary:
    
30.         //     [8] Saves the results of rows after filtering them to the Excel-compatible
    
31.         //     file.
    
32.         SaveAsFiltered = 8,
    
33.         //
    
34.         // Summary:
    
35.         //     [16] Saves the spreadsheet to an Excel 2007 (OfficeOpen XML) format.
    
36.         UseOOXMLFormat = 16,
    
37.         //
    
38.         // Summary:
    
39.         //     [32] Saves only the data to the Excel-compatible file.
    
40.         DataOnly = 32,
    
41.         //
    
42.         // Summary:
    
43.         //     [64] Saves the appearance settings of alternating rows to the Excel-compatible
    
44.         //     file.
    
45.         SaveAlternatingRowStyles = 64,
    
46.         //
    
47.         // Summary:
    
48.         //     [136] Saves the spreadsheet as viewed to the Excel-compatible file.
    
49.         SaveAsViewed = 136,
    
50.         //
    
51.         // Summary:
    
52.         //     [256] Uses a custom color palette, and uses it for color approximations if
    
53.         //     there are more than 56 colors set into Spread.
    
54.         UseCustomPaletteForColorApproximations = 256,
    
55.         //
    
56.         // Summary:
    
57.         //     [512] Uses the default color palette.
    
58.         UseDefaultColorPalette = 512,
    
59.         //
    
60.         // Summary:
    
61.         //     [1024] Saves the displayed data and formatting, but not the notes.
    
62.         NoNotes = 1024,
    
63.         //
    
64.         // Summary:
    
65.         //     [2048] Keeps Excel data that was previously loaded from the files (e.g. VBA,
    
66.         //     Macro).
    
67.         DocumentCaching = 2048,
    
68.         //
    
69.         // Summary:
    
70.         //     [4096] The default row height is not saved. Excel will automatically determine
    
71.         //     row heights based on the largest font that is set in each row.
    
72.         AutoRowHeight = 4096,
    
73.         //
    
74.         // Summary:
    
75.         //     [8192] Saves the displayed data in the combobox celltype, does not save the
    
76.         //     items in the combo box.
    
77.         ComboDataOnly = 8192,
    
78.     }
    
79. 
    

复制代码