VaSpread和FpSpread控件有什么区别阿 ?
怎么用FpSpread控件?请高人指点阿!!!!
怎么用FpSpread控件?请高人指点阿!!!!
解决方案 »
- C#选项卡 问题请教
- 进度条
- 高分求助!!!c #下载为什么只能下载象.txt\.word扩展名的文件,而下载无法执行文件就出错????????????
- CrystalReport在C# WinForm中的部署问题
- 麻烦大家帮忙看下,窗口显示不出来
- 思归 大哥请进,请教一个关于 从XML文件反序列化对象的问题?
- 难! TreeView拖拉时的问题
- Office 2003嵌入开发问题!
- 如何让Notify实现系统热键功能?
- 请教高手:关于vs.net技术文档附带的那个Duwamish 7.0例子的安装的问题
- SlickUpload 是免费使用的吗
- spread事件的基础问题,知者不难,我不熟悉所以很难。帮帮忙吧!!!!!问题不难
'
' 'datareader
'
'
'***************************************************************
'Dim strcon As String = "server=zhangln;database=northwind;uid=sa;pwd=;"
'Dim con As New SqlClient.SqlConnection(strcon)
'con.Open()
'Dim cmd As New SqlClient.SqlCommand
'Dim dreader As SqlClient.SqlDataReader
'With cmd
' .Connection = con
' .CommandText = "select * from Employees"
' .CommandType = CommandType.Text
' dreader = .ExecuteReader
'End With
'Me.AxfpSpread1.MaxRows = 0
'Me.AxfpSpread1.MaxCols = dreader.FieldCount
'Me.AxfpSpread1.Row = 1
'Me.AxfpSpread1.Col = 1
'Me.AxfpSpread1.Row2 = AxfpSpread1.MaxRows
'Me.AxfpSpread1.Col2 = AxfpSpread1.MaxCols 'Dim i, j As Integer
'i = 1
'Do While (dreader.Read)
' Me.AxfpSpread1.MaxRows = Me.AxfpSpread1.MaxRows + 2
' Me.AxfpSpread1.Row2 = AxfpSpread1.MaxRows
' For j = 1 To dreader.FieldCount
' Me.AxfpSpread1.Row = i
' Me.AxfpSpread1.Col = j
' Me.AxfpSpread1.Value = dreader.Item(j - 1).ToString
' Next
' i += 1
'Loop
'---------------------------------------------------------------------
'***************************************************************
'
'
'dataset
'
'
'***************************************************************
'Dim strcon As String = "server=zhangln;database=northwind;uid=sa;pwd=;"
'Dim con As New SqlClient.SqlConnection(strcon)
'con.Open()
'Dim strsql As String = "select EmployeeID,LastName from Employees"
'Dim ada As New SqlClient.SqlDataAdapter(strsql, con)
'Dim dts As New DataSet
'ada.Fill(dts)
'If Me.pid <> 0 Then
' Dim dr As DataRow
' dr = dts.Tables(0).NewRow
' dr.Item(0) = Me.pid
' dr.Item(1) = Me.pname
' dts.Tables(0).Rows.Add(dr)
'End If
'Try
' Me.AxfpSpread1.MaxRows = dts.Tables(0).Rows.Count
' Me.AxfpSpread1.MaxCols = dts.Tables(0).Columns.Count
' Me.AxfpSpread1.Row = 1
' Me.AxfpSpread1.Col = 1
' Me.AxfpSpread1.Row2 = AxfpSpread1.MaxRows
' Me.AxfpSpread1.Col2 = AxfpSpread1.MaxCols
' Dim i, j As Integer
' For i = 1 To dts.Tables(0).Rows.Count
' For j = 1 To dts.Tables(0).Columns.Count
' Me.AxfpSpread1.Row = i
' Me.AxfpSpread1.Col = j
' Me.AxfpSpread1.Value = dts.Tables(0).Rows(i - 1)(j - 1).ToString
' Next
' Next
' 'Me.AxfpSpread1.Row = i + 1
' 'Me.AxfpSpread1.Value.Insert(0, 1)
'Catch ex As Exception 'End Try
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using FarPoint.Web.Spread.Editor;
namespace Sundyn_GXQ.Report
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected FarPoint.Web.Spread.FpSpread FpSpread1;
FarPoint.Web.Spread.Editor.GeneralEditor editor=new GeneralEditor();
private string[] ReportList;
protected System.Web.UI.WebControls.Button Button1;
private string OrgnizeCode;
private string DirPath="UpLoad\\"+"新区党总支";
private string FileName; private void Page_Load(object sender, System.EventArgs e)
{
//在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
//try
//{
// FpSpread1.Sheets.Count=6;
InitReport();
// ImportExcel("党员基本信息.xls",0);
// ImportExcel("党组织数量情况和党的基层组织换届情况.xls",1);
// ImportExcel("两年党员数综合比较.xls",2);
// ImportExcel("外出流动党员情况.xls",3);
// ImportExcel("接收流动党员情况.xls",4);
// ImportExcel("党费收支结存情况统计表.xls",5);
AddValue(0,0);
FpSpread1.CommandBar.Visible=true;
//}
// catch(System.Exception ex )
// {
//Response.Write("<script>alert(\"警告:模板未能完全加载,请检查是否有模板文件被占用或损坏!\");</script>");
// Response.Write(ex.ToString());
// }
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.FpSpread1.UpdateCommand += new FarPoint.Web.Spread.SpreadCommandEventHandler(this.FpSpread1_UpdateCommand);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
private void InitReport()
{
ReportList=Request.Form["ListBox1"].Split(',');
OrgnizeCode=Request.Form["OrgnizeCode"];
FpSpread1.Sheets.Count=ReportList.Length;
for(int i=0;i<ReportList.Length;i++)
ImportExcel(ReportList[i]+".xls",i);
} private void ImportExcel(string FileName,int SpreadSheetNum)//根据文件名和在farpoint的Sheet号装入Excel文档
{
string FilePath=Server.MapPath(FileName);
FpSpread1.OpenExcel(FilePath,SpreadSheetNum,0);
FpSpread1.Sheets[SpreadSheetNum].PageSize=25;
FpSpread1.Sheets[SpreadSheetNum].RowHeader.Visible=false;
FpSpread1.Sheets[SpreadSheetNum].ColumnHeader.Visible=false;
FpSpread1.CommandBar.Visible=false;
string[] SheetName=FileName.Split('.');
//if(SheetName[0].Length>6)
// SheetName[0]=SheetName[0].Substring(0,5)+"...";
FpSpread1.Sheets[SpreadSheetNum].SheetName=SheetName[0];
FpSpread1.Sheets[SpreadSheetNum].SheetCornerStyle.Font.Size=10;
}
private void AddValue(int SpreadSheetNum,int Num)//根据编号来调用数据库统计信息
{
Sundyn_GXQ.BLL.common common=new Sundyn_GXQ.BLL.common();
DataSet MyReportData=common.GetMemBasicInfo();
for(int i=5;i<17;i++)
{
FpSpread1.Sheets[SpreadSheetNum].Cells[i,5].Text=MyReportData.Tables[0].Rows[0][i-5].ToString();
FpSpread1.Sheets[SpreadSheetNum].Cells[i,5].Editor=editor;
}
for(int i=5;i<16;i++)
FpSpread1.Sheets[SpreadSheetNum].Cells[i,11].Text=MyReportData.Tables[0].Rows[0][i+7].ToString();
} private void SaveExcelFile()
{
System.IO.Directory.CreateDirectory(Server.MapPath(DirPath));
FileName=System.DateTime.Now.ToString().Replace(':','-').Replace(' ','-');
string newfilepath = Server.MapPath(DirPath+"\\"+FileName+".xls");
if(FpSpread1.SaveExcel(newfilepath))
Response.Write("<script>alert(\"保存成功!\");</script>");
else
Response.Write("<script>alert(\"保存失败,请重新保存或联系管理员!\");</script>");
} //SaveExcelFile
private void Button1_Click(object sender, System.EventArgs e)
{
SaveExcelFile();
} private void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
}
}
}
你用的是Spread for .NET控件,可以用fpSpread1.ActiveSheet.Cells(2, 0).Value = "hello"