spread for asp.net 模板及数据保存与读取问题

收藏

我们想实现简单的bs的excel功能，希望保存的模板及数据都存放在数据库中，经过测试，有以下疑问
1、通过IDE的设计器设计后的模板如何直接变成文本格式，从aspx中复制需要处理转义字符，不太方便
2、通过IDE设计器设计后的xml与通过后台代码Save文件流生成的xml不同，save生成的xml缺少一些内容。Button1_Click是通过IDE设计器设计后的xml，Button2_Click可以生成后台xml，Button3_Click是将Button2_Click生成的后台xml设置成控件的designString.
3、因为Save文件流生成的xml好像缺少一些配置，导致有部分Data数据无法显示，可以直接运行后点击Button3测试。

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Spread.Test.Default" %>
<%@ Register Assembly="FarPoint.Web.Spread, Version=6.0.3505.2008, Culture=neutral, PublicKeyToken=327c3516b1b18457"
Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<FarPoint:FpSpread ID="FpSpread1" runat="server" BorderStyle="Solid"
BorderWidth="1px" BorderColor="Black" DesignString='<?xml version="1.0" encoding="utf-8"?><Spread />'
EnableTheming="True" ActiveSheetViewIndex="0"
currentPageIndex="0" Height="230px" Width="556px">
<Sheets>
<FarPoint:SheetView SheetName="Sheet1"
DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Sheet&gt;&lt;Data&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;6&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;6&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;SheetName&gt;Sheet1&lt;/SheetName&gt;&lt;Cells&gt;&lt;Cell row=&quot;1&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;用户名称&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;性别&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;2&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;下拉测试&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;5&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnFooter&gt;&lt;/Data&gt;&lt;Presentation&gt;&lt;AxisModels&gt;&lt;Column class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;5&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/Column&gt;&lt;RowHeaderColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;40&quot; orientation=&quot;Horizontal&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;40&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RowHeaderColumn&gt;&lt;ColumnHeaderRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnHeaderRow&gt;&lt;ColumnFooterRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnFooterRow&gt;&lt;/AxisModels&gt;&lt;StyleModels&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;6&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;RowHeaderDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnHeaderDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;6&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;DataAreaDefault&quot; /&gt;&lt;CellStyles&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;1&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.TextCellType&quot;&gt;&lt;t /&gt;&lt;/c&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;3&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.RadioButtonListCellType&quot;&gt;&lt;i&gt;&lt;m t=&quot;男&quot; v=&quot;0&quot; /&gt;&lt;m t=&quot;女&quot; v=&quot;1&quot; /&gt;&lt;/i&gt;&lt;/c&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;2&quot; Column=&quot;1&quot;&gt;&lt;c class=&quot;FarPoint.Web.Spread.ComboBoxCellType&quot;&gt;&lt;h&gt;&lt;d t=&quot;A&quot; v=&quot;0&quot; /&gt;&lt;d t=&quot;B&quot; v=&quot;1&quot; /&gt;&lt;/h&gt;&lt;/c&gt;&lt;/CellStyle&gt;&lt;/CellStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ConditionalFormatCollections /&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;5&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnFooterDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnFooter&gt;&lt;/StyleModels&gt;&lt;MessageRowStyle class=&quot;FarPoint.Web.Spread.Appearance&quot;&gt;&lt;BackColor&gt;LightYellow&lt;/BackColor&gt;&lt;ForeColor&gt;Red&lt;/ForeColor&gt;&lt;/MessageRowStyle&gt;&lt;SheetCornerStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/SheetCornerStyle&gt;&lt;AllowLoadOnDemand&gt;false&lt;/AllowLoadOnDemand&gt;&lt;LoadRowIncrement &gt;10&lt;/LoadRowIncrement &gt;&lt;LoadInitRowCount &gt;30&lt;/LoadInitRowCount &gt;&lt;AllowVirtualScrollPaging&gt;false&lt;/AllowVirtualScrollPaging&gt;&lt;TopRow&gt;0&lt;/TopRow&gt;&lt;PreviewRowStyle class=&quot;FarPoint.Web.Spread.PreviewRowInfo&quot; /&gt;&lt;/Presentation&gt;&lt;Settings&gt;&lt;Name&gt;Sheet1&lt;/Name&gt;&lt;Categories&gt;&lt;Appearance&gt;&lt;GridLineColor&gt;#d0d7e5&lt;/GridLineColor&gt;&lt;SelectionBackColor&gt;#eaecf5&lt;/SelectionBackColor&gt;&lt;SelectionBorder class=&quot;FarPoint.Web.Spread.Border&quot; /&gt;&lt;/Appearance&gt;&lt;Behavior&gt;&lt;EditTemplateColumnCount&gt;2&lt;/EditTemplateColumnCount&gt;&lt;GroupBarText&gt;Drag a column to group by that column.&lt;/GroupBarText&gt;&lt;/Behavior&gt;&lt;Layout&gt;&lt;RowHeaderColumnCount&gt;1&lt;/RowHeaderColumnCount&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;RowCount&gt;6&lt;/RowCount&gt;&lt;ColumnCount&gt;5&lt;/ColumnCount&gt;&lt;/Layout&gt;&lt;/Categories&gt;&lt;ActiveRow&gt;2&lt;/ActiveRow&gt;&lt;ActiveColumn&gt;1&lt;/ActiveColumn&gt;&lt;ColumnHeaderRowCount&gt;1&lt;/ColumnHeaderRowCount&gt;&lt;ColumnFooterRowCount&gt;1&lt;/ColumnFooterRowCount&gt;&lt;PrintInfo&gt;&lt;Header /&gt;&lt;Footer /&gt;&lt;ZoomFactor&gt;0&lt;/ZoomFactor&gt;&lt;FirstPageNumber&gt;1&lt;/FirstPageNumber&gt;&lt;Orientation&gt;Auto&lt;/Orientation&gt;&lt;PrintType&gt;All&lt;/PrintType&gt;&lt;PageOrder&gt;Auto&lt;/PageOrder&gt;&lt;BestFitCols&gt;False&lt;/BestFitCols&gt;&lt;BestFitRows&gt;False&lt;/BestFitRows&gt;&lt;PageStart&gt;-1&lt;/PageStart&gt;&lt;PageEnd&gt;-1&lt;/PageEnd&gt;&lt;ColStart&gt;-1&lt;/ColStart&gt;&lt;ColEnd&gt;-1&lt;/ColEnd&gt;&lt;RowStart&gt;-1&lt;/RowStart&gt;&lt;RowEnd&gt;-1&lt;/RowEnd&gt;&lt;ShowBorder&gt;True&lt;/ShowBorder&gt;&lt;ShowGrid&gt;True&lt;/ShowGrid&gt;&lt;ShowColor&gt;True&lt;/ShowColor&gt;&lt;ShowColumnHeader&gt;Inherit&lt;/ShowColumnHeader&gt;&lt;ShowRowHeader&gt;Inherit&lt;/ShowRowHeader&gt;&lt;ShowColumnFooter&gt;Inherit&lt;/ShowColumnFooter&gt;&lt;ShowColumnFooterEachPage&gt;True&lt;/ShowColumnFooterEachPage&gt;&lt;ShowTitle&gt;True&lt;/ShowTitle&gt;&lt;ShowSubtitle&gt;True&lt;/ShowSubtitle&gt;&lt;UseMax&gt;True&lt;/UseMax&gt;&lt;UseSmartPrint&gt;False&lt;/UseSmartPrint&gt;&lt;Opacity&gt;255&lt;/Opacity&gt;&lt;PrintNotes&gt;None&lt;/PrintNotes&gt;&lt;Centering&gt;None&lt;/Centering&gt;&lt;RepeatColStart&gt;-1&lt;/RepeatColStart&gt;&lt;RepeatColEnd&gt;-1&lt;/RepeatColEnd&gt;&lt;RepeatRowStart&gt;-1&lt;/RepeatRowStart&gt;&lt;RepeatRowEnd&gt;-1&lt;/RepeatRowEnd&gt;&lt;SmartPrintPagesTall&gt;1&lt;/SmartPrintPagesTall&gt;&lt;SmartPrintPagesWide&gt;1&lt;/SmartPrintPagesWide&gt;&lt;HeaderHeight&gt;-1&lt;/HeaderHeight&gt;&lt;FooterHeight&gt;-1&lt;/FooterHeight&gt;&lt;/PrintInfo&gt;&lt;TitleInfo class=&quot;FarPoint.Web.Spread.TitleInfo&quot;&gt;&lt;Style class=&quot;FarPoint.Web.Spread.StyleInfo&quot;&gt;&lt;BackColor&gt;#e7eff7&lt;/BackColor&gt;&lt;HorizontalAlign&gt;Right&lt;/HorizontalAlign&gt;&lt;/Style&gt;&lt;/TitleInfo&gt;&lt;LayoutTemplate class=&quot;FarPoint.Web.Spread.LayoutTemplate&quot;&gt;&lt;Layout&gt;&lt;ColumnCount&gt;4&lt;/ColumnCount&gt;&lt;RowCount&gt;1&lt;/RowCount&gt;&lt;/Layout&gt;&lt;Data&gt;&lt;LayoutData class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;2&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;3&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/LayoutData&gt;&lt;/Data&gt;&lt;AxisModels&gt;&lt;LayoutColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;4&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/LayoutColumn&gt;&lt;LayoutRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot; /&gt;&lt;/Items&gt;&lt;/LayoutRow&gt;&lt;/AxisModels&gt;&lt;/LayoutTemplate&gt;&lt;LayoutMode&gt;CellLayoutMode&lt;/LayoutMode&gt;&lt;CurrentPageIndex type=&quot;System.Int32&quot;&gt;0&lt;/CurrentPageIndex&gt;&lt;/Settings&gt;&lt;/Sheet&gt;">
</FarPoint:SheetView>
</Sheets>
<TitleInfo BackColor="#E7EFF7" Font-Size="X-Large" HorizontalAlign="Center"
font-bold="False" font-italic="False" font-overline="False"
font-strikeout="False" font-underline="False">
</TitleInfo>
<HierBar Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" />
<Pager Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" />
<CommandBar BackColor="Transparent">
<Background BackgroundImageUrl="SPREADCLIENTPATH:/img/cbbg.gif"></Background>
</CommandBar>
</FarPoint:FpSpread>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click"
Text="Button1" />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click"
Text="Button2" />
<asp:Button ID="Button3" runat="server" onclick="Button3_Click"
Text="Button3" />
</div>
</form>
</body>
</html>

复制代码

easypower · easypower

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
namespace Spread.Test
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
FpSpread1.Sheets[0].DesignString =
@"<?xml version=""1.0"" encoding=""utf-8""?>
<Sheet>
<Data>
<RowHeader class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""3"" columns=""1"">
<AutoCalculation>True</AutoCalculation>
<AutoGenerateColumns>True</AutoGenerateColumns>
<ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration>
<MaximumIterations>1</MaximumIterations>
<MaximumChange>0.001</MaximumChange>
</RowHeader>
<ColumnHeader class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""1"" columns=""4"">
<AutoCalculation>True</AutoCalculation>
<AutoGenerateColumns>True</AutoGenerateColumns>
<ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration>
<MaximumIterations>1</MaximumIterations>
<MaximumChange>0.001</MaximumChange>
</ColumnHeader>
<DataArea class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""3"" columns=""4"">
<AutoCalculation>True</AutoCalculation>
<AutoGenerateColumns>True</AutoGenerateColumns>
<ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration>
<MaximumIterations>1</MaximumIterations>
<MaximumChange>0.001</MaximumChange>
<SheetName>SheetABC</SheetName>
<Cells>
<Cell row=""0"" column=""0"">
<Data type=""System.Int32"">123</Data>
</Cell>
<Cell row=""1"" column=""1"">
<Data type=""System.Int32"">234</Data>
</Cell>
<Cell row=""2"" column=""2"">
<Data type=""System.Int32"">345</Data>
</Cell>
</Cells>
</DataArea>
<SheetCorner class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""1"" columns=""1"">
<AutoCalculation>True</AutoCalculation>
<AutoGenerateColumns>True</AutoGenerateColumns>
<ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration>
<MaximumIterations>1</MaximumIterations>
<MaximumChange>0.001</MaximumChange>
</SheetCorner>
<ColumnFooter class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""1"" columns=""4"">
<AutoCalculation>True</AutoCalculation>
<AutoGenerateColumns>True</AutoGenerateColumns>
<ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration>
<MaximumIterations>1</MaximumIterations>
<MaximumChange>0.001</MaximumChange>
</ColumnFooter>
</Data>
<Presentation>
<HeaderGrayAreaColor>#7999c2</HeaderGrayAreaColor>
<AxisModels>
<Column class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" orientation=""Horizontal"" count=""4"">
<Items>
<Item index=""-1"">
<SortIndicator>Ascending</SortIndicator>
</Item>
</Items>
</Column>
<RowHeaderColumn class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" defaultSize=""40"" orientation=""Horizontal"" count=""1"">
<Items>
<Item index=""-1"">
<Size>40</Size>
<SortIndicator>Ascending</SortIndicator>
</Item>
</Items>
</RowHeaderColumn>
<ColumnHeaderRow class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" defaultSize=""22"" orientation=""Vertical"" count=""1"">
<Items>
<Item index=""-1"">
<Size>22</Size>
</Item>
</Items>
</ColumnHeaderRow>
<ColumnFooterRow class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" defaultSize=""22"" orientation=""Vertical"" count=""1"">
<Items>
<Item index=""-1"">
<Size>22</Size>
</Item>
</Items>
</ColumnFooterRow>
</AxisModels>
<StyleModels>
<RowHeader class=""FarPoint.Web.Spread.Model.DefaultSheetStyleModel"" Rows=""3"" Columns=""1"">
<AltRowCount>2</AltRowCount>
<DefaultStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""RowHeaderDefault"" />
<ConditionalFormatCollections />
</RowHeader>
<ColumnHeader class=""FarPoint.Web.Spread.Model.DefaultSheetStyleModel"" Rows=""1"" Columns=""4"">
<AltRowCount>2</AltRowCount>
<DefaultStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""ColumnHeaderDefault"">
<Background class=""FarPoint.Web.Spread.Background"">
<BackgroundImageUrl>{SPREADCLIENTPATH}/img/chbg.gif</BackgroundImageUrl>
<SelectedBackgroundImageUrl>{SPREADCLIENTPATH}/img/chm.png</SelectedBackgroundImageUrl>
</Background>
</DefaultStyle>
<ConditionalFormatCollections />
</ColumnHeader>
<DataArea class=""FarPoint.Web.Spread.Model.DefaultSheetStyleModel"" Rows=""3"" Columns=""4"">
<AltRowCount>2</AltRowCount>
<DefaultStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""DataAreaDefault"" />
<ConditionalFormatCollections />
</DataArea>
<SheetCorner class=""FarPoint.Web.Spread.Model.DefaultSheetStyleModel"" Rows=""1"" Columns=""1"">
<AltRowCount>2</AltRowCount>
<DefaultStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""CornerDefault"">
<Background class=""FarPoint.Web.Spread.Background"">
<BackgroundImageUrl>{SPREADCLIENTPATH}/img/chbg.gif</BackgroundImageUrl>
<SelectedBackgroundImageUrl>{SPREADCLIENTPATH}/img/chm.png</SelectedBackgroundImageUrl>
</Background>
</DefaultStyle>
<ConditionalFormatCollections />
</SheetCorner>
<ColumnFooter class=""FarPoint.Web.Spread.Model.DefaultSheetStyleModel"" Rows=""1"" Columns=""4"">
<AltRowCount>2</AltRowCount><DefaultStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""ColumnFooterDefault"" />
<ConditionalFormatCollections /></ColumnFooter></StyleModels><MessageRowStyle class=""FarPoint.Web.Spread.Appearance"">
<BackColor>LightYellow</BackColor><ForeColor>Red</ForeColor></MessageRowStyle><SheetCornerStyle class=""FarPoint.Web.Spread.NamedStyle"" Parent=""CornerDefault"">
<Background class=""FarPoint.Web.Spread.Background""><BackgroundImageUrl>{SPREADCLIENTPATH}/img/chbg.gif</BackgroundImageUrl>
<SelectedBackgroundImageUrl>{SPREADCLIENTPATH}/img/chm.png</SelectedBackgroundImageUrl></Background></SheetCornerStyle>
<AllowLoadOnDemand>false</AllowLoadOnDemand><LoadRowIncrement >10</LoadRowIncrement ><LoadInitRowCount >30</LoadInitRowCount >
<TopRow>0</TopRow><PreviewRowStyle class=""FarPoint.Web.Spread.PreviewRowInfo""><TabStop>False</TabStop></PreviewRowStyle>
</Presentation><Settings><Name>Sheet1</Name><Categories><Appearance><GridLineColor>#d0d7e5</GridLineColor><SelectionBorder class=""FarPoint.Web.Spread.Border"" />
<HeaderGrayAreaColor>#7999c2</HeaderGrayAreaColor><SelectionBackColor>#eaecf5</SelectionBackColor></Appearance><Behavior /><Layout>
<RowHeaderColumnCount>1</RowHeaderColumnCount><ColumnHeaderRowCount>1</ColumnHeaderRowCount></Layout></Categories>
<ColumnHeaderRowCount>1</ColumnHeaderRowCount><ColumnFooterRowCount>1</ColumnFooterRowCount><TitleInfo class=""FarPoint.Web.Spread.TitleInfo"">
<Style class=""FarPoint.Web.Spread.StyleInfo""><BackColor>#e7eff7</BackColor><HorizontalAlign>Right</HorizontalAlign></Style>
</TitleInfo><LayoutTemplate class=""FarPoint.Web.Spread.LayoutTemplate""><Layout><ColumnCount>4</ColumnCount><RowCount>1</RowCount>
</Layout><Data><LayoutData class=""FarPoint.Web.Spread.Model.DefaultSheetDataModel"" rows=""1"" columns=""4"">
<AutoCalculation>True</AutoCalculation><AutoGenerateColumns>True</AutoGenerateColumns><ReferenceStyle>A1</ReferenceStyle>
<Iteration>False</Iteration><MaximumIterations>1</MaximumIterations><MaximumChange>0.001</MaximumChange></LayoutData>
</Data><AxisModels><LayoutColumn class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" orientation=""Horizontal"" count=""4"">
<Items><Item index=""-1""><SortIndicator>Ascending</SortIndicator></Item></Items></LayoutColumn>
<LayoutRow class=""FarPoint.Web.Spread.Model.DefaultSheetAxisModel"" orientation=""Vertical"" count=""1"">
<Items><Item index=""-1"" /></Items></LayoutRow></AxisModels></LayoutTemplate><LayoutMode>CellLayoutMode</LayoutMode>
</Settings>
</Sheet>";
}
protected void Button2_Click(object sender, EventArgs e)
{
MemoryStream stream = new MemoryStream();
FpSpread1.Sheets[0].Save(stream, true);
string str = System.Text.Encoding.UTF8.GetString(stream.ToArray());
}
protected void Button3_Click(object sender, EventArgs e)
{
?FpSpread1.Sheets[0].DesignString = "<?xml version="1.0" encoding="utf-8"?>\r\n<Sheet class="FarPoint.Web.Spread.SheetView">\r\n \r\n <Data>\r\n <DataArea class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="4">\r\n <AutoCalculation>True</AutoCalculation>\r\n <AutoGenerateColumns>True</AutoGenerateColumns>\r\n <ReferenceStyle>A1</ReferenceStyle>\r\n <Iteration>False</Iteration>\r\n <MaximumIterations>1</MaximumIterations>\r\n <MaximumChange>0.001</MaximumChange>\r\n <SheetName>Sheet1</SheetName>\r\n <Cells>\r\n <Cell row="0" column="0">\r\n <Data type="System.Int32">123</Data>\r\n </Cell>\r\n <Cell row="0" column="1">\r\n <Data type="System.String">bbb</Data>\r\n </Cell>\r\n <Cell row="0" column="2">\r\n <Data type="System.String">ccc</Data>\r\n </Cell>\r\n <Cell row="1" column="1">\r\n <Data type="System.Int32">234</Data>\r\n </Cell>\r\n <Cell row="1" column="2">\r\n <Data type="System.String">qqq</Data>\r\n </Cell>\r\n <Cell row="2" column="1">\r\n <Data type="System.String">ddd</Data>\r\n </Cell>\r\n <Cell row="2" column="2">\r\n <Data type="System.Int32">345</Data>\r\n </Cell>\r\n </Cells>\r\n </DataArea>\r\n <RowHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="3" columns="1">\r\n <AutoCalculation>True</AutoCalculation>\r\n <AutoGenerateColumns>True</AutoGenerateColumns>\r\n <ReferenceStyle>A1</ReferenceStyle>\r\n <Iteration>False</Iteration>\r\n <MaximumIterations>1</MaximumIterations>\r\n <MaximumChange>0.001</MaximumChange>\r\n </RowHeader>\r\n <ColumnHeader class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="1" columns="4">\r\n <AutoCalculation>True</AutoCalculation>\r\n <AutoGenerateColumns>True</AutoGenerateColumns>\r\n <ReferenceStyle>A1</ReferenceStyle>\r\n <Iteration>False</Iteration>\r\n <MaximumIterations>1</MaximumIterations>\r\n <MaximumChange>0.001</MaximumChange>\r\n </ColumnHeader>\r\n <SheetCorner class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="1" columns="1">\r\n <AutoCalculation>True</AutoCalculation>\r\n <AutoGenerateColumns>True</AutoGenerateColumns>\r\n <ReferenceStyle>A1</ReferenceStyle>\r\n <Iteration>False</Iteration>\r\n <MaximumIterations>1</MaximumIterations>\r\n <MaximumChange>0.001</MaximumChange>\r\n </SheetCorner>\r\n <ColumnFooter class="FarPoint.Web.Spread.Model.DefaultSheetDataModel" rows="1" columns="4">\r\n <AutoCalculation>True</AutoCalculation>\r\n <AutoGenerateColumns>True</AutoGenerateColumns>\r\n <ReferenceStyle>A1</ReferenceStyle>\r\n <Iteration>False</Iteration>\r\n <MaximumIterations>1</MaximumIterations>\r\n <MaximumChange>0.001</MaximumChange>\r\n </ColumnFooter>\r\n </Data>\r\n</Sheet>";
}
}
}

复制代码

iceman · iceman

easypower 你好，
能否上传 Demo 到论坛调试？
问题我们已经接收，明天回复。

easypower · easypower

页面前台后台代码都已上传啊

iceman · iceman

easypower 你好
该问题正在处理中，我会尽快回复～

iceman · iceman

easypower 你好，
通过IDE的设计器设计后的模板如何直接变成文本格式，从aspx中复制需要处理转义字符，不太方便

在设计器中设置好格式之后，我们可以使用设计器直接保存格式，请参考截图：

savebydesigner.png (47.68 KB, 下载次数: 563)

easypower · easypower

感谢回复，第2个问题和第3个问题也请回复一下

iceman · iceman

easypower 你好，
关于问题 2 和 问题 3 在 6# Demo 中已经测试，请参考。
Demo 中分别使用两个 Button 加载通过 Spread 设计器生成的 XML 和通过后台代码保存的 XML 。并没有出现 1# 中提到的问题。

elwin · elwin

版主，随便问一下：我的模板是从EXECL中导过来，在用户填写EXECL的模板后，能不能实现EXECL模板和用户填写的数据分开保存？当用户需要查看他所填写的内容时候，我们能否实现把数据和EXECL模板合并在一块展示给用户？

iceman · iceman

elwin 你好，
可以实现该功能，下面是测试 Demo（内附功能注释）：
测试环境：VS2010 && Spread for .NET 6.0

SeperateStyleAndData.zip (21.66 KB, 下载次数: 510)

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

[已处理] spread for asp.net 模板及数据保存与读取问题

13 个回复

回复 1# easypower 的帖子

回复 2# easypower 的帖子

回复 4# easypower 的帖子

回复 7# easypower 的帖子

活字格认证

微信认证勋章

元老葡萄