高分求助 “怎么通过FpSpread控件显示数据”?谢谢 急急 !!!!! VaSpread和FpSpread控件有什么区别阿 ?怎么用FpSpread控件?请高人指点阿!!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 '*************************************************************** ' ' '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 能不能用C#写一个阿 我不会VB 55555555555555555555555555 这个fpSpread1.Row 没有啊 fpSpread1.里没有Row ,Col 等等 这是我最近用的调用excel的代码你可以参考一下using System;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) { } }} 我想做的东西是基于FORM的 这个是就网络的 这两个好像不太一样啊 55555555 Row和Col是Spread里面的属性你用的是Spread for .NET控件,可以用fpSpread1.ActiveSheet.Cells(2, 0).Value = "hello" 能分享下COMMAND BAR上的对号(更新)和删除代码吗?刚接触还不会,谢谢 初学C#,想知道,怎么单独把与数据库链接的代码单另写到一个类里? excel中的图片复制到剪切板之后处理 winfrom里面怎么的把listbox的内容复制出来啊 DataTable 怎样计算一个字符串的长度 数组转成字符串问题 关与datagridview的取内容问题! 请各位大侠帮帮忙,谁在VS C#中用过柯达控件!!! 如何判断数据集是否为空? 我在winform上画出来的带箭头直线为什么是这个样子? 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"