要是服务器上没有装着excel 可以用c#导出excel表吗

可以使用二进制读写Excel的开源组件orgin2bitsMyXlsdll导出真正的Excel文件。
以下是我简单封装的一个ExcelHelper
using System;
using SystemData;
using SystemConfiguration;
using SystemWeb;
using SystemWebSecurity;
using SystemWebUI;
using SystemWebUIHtmlControls;
using SystemWebUIWebControls;
using SystemWebUIWebControlsWebParts;
using SystemCollectionsGeneric;
using orgin2bitsMyXls;
using orgin2bitsMyXlsByteUtil;
/// <summary>
///ExcelHelper 的摘要说明
/// </summary>
public class ExcelHelper
{
protected ExcelHelper()
{
}
public class TableStruct
{
private string _TableName;
private string _TableCaption;
private List<ColumnStruct> _ColumnInfoAry;
public string TableName
{
get
{
if (stringIsNullOrEmpty(_TableName))
{
return stringEmpty;
}
return _TableName;
}
set
{
_TableName = value;
}
}
public string TableCaption
{
get
{
if (stringIsNullOrEmpty(_TableCaption))
{
return TableName;
}
return _TableCaption;
}
set
{
_TableCaption = value;
}
}
public List<ColumnStruct> ColumnInfoAry
{
get
{
if (_ColumnInfoAry == null)
{
_ColumnInfoAry = new List<ColumnStruct>();
}
return _ColumnInfoAry;
}
}
public void AddColumnInfo(ColumnStruct ColumnInfo)
{
if (ColumnInfo == null)
{
return;
}
if (_ColumnInfoAry == null)
{
_ColumnInfoAry = new List<ColumnStruct>();
}
foreach (ColumnStruct col in _ColumnInfoAry)
{
if (colColumnNameEquals(ColumnInfoColumnName, StringComparisonOrdinalIgnoreCase))
{
return;
}
}
_ColumnInfoAryAdd(ColumnInfo);
}
public ColumnStruct GetColumnInfo(string ColumnName)
{
if (stringIsNullOrEmpty(ColumnName) )
{
return null;
}
if (_ColumnInfoAry == null)
{
return null;
}
ColumnStruct ColumnInfo = null;
foreach (ColumnStruct col in _ColumnInfoAry)
{
if (colColumnNameEquals(ColumnName, StringComparisonOrdinalIgnoreCase))
{
ColumnInfo = col;
}
}
return ColumnInfo;
}
}
public class ColumnStruct
{
private string _ColumnName;
private string _ColumnCaption;
private string _ColumnTextFormat;
public string ColumnName
{
get
{
if (stringIsNullOrEmpty(_ColumnName))
{
return stringEmpty;
}
return _ColumnName;
}
set
{
_ColumnName = value;
}
}
public string ColumnCaption
{
get
{
if (stringIsNullOrEmpty(_ColumnCaption))
{
return ColumnName;
}
return _ColumnCaption;
}
set
{
_ColumnCaption = value;
}
}
public string ColumnTextFormat
{
get
{
if (stringIsNullOrEmpty(_ColumnTextFormat))
{
return stringEmpty;
}
return _ColumnTextFormat;
}
set
{
_ColumnTextFormat = value;
}
}
}
public static void ExportToExcel(DataSet ds,List<TableStruct> TableInfoAry)
{
if (ds == null)
{
ds = new DataSet();
}
if ( TableInfoAry == null )
{
TableInfoAry = new List<TableStruct>();
}
XlsDocument xls = new XlsDocument();
xlsFileName = DateTimeNowToString("yyyyMMddHHmmssffff",SystemGlobalizationDateTimeFormatInfoInvariantInfo);
xlsSummaryInformationAuthor = "wangmh"; //填加xls文件作者信息
xlsSummaryInformationNameOfCreatingApplication = "Microsoft Excel"; //填加xls文件创建程序信息
xlsSummaryInformationLastSavedBy = "wangmh"; //填加xls文件最后保存者信息
xlsSummaryInformationComments = "Gwm"; //填加xls文件作者信息
xlsSummaryInformationTitle = "Gwm"; //填加xls文件标题信息
xlsSummaryInformationSubject = "Gwm";//填加文件主题信息
xlsDocumentSummaryInformationCompany = "Gwm";//填加文件公司信息
foreach (TableStruct TableInfo in TableInfoAry)
{
DataTable dt = dsTables[TableInfoTableName];
if (dt == null)
{
continue;
}
Worksheet sheet = xlsWorkbookWorksheetsAdd(TableInfoTableCaption);

//设置标头栏
ushort ColumnIndex = 1;
foreach (ColumnStruct ColStruct in TableInfoColumnInfoAry)
{
ushort RowIndex = 1;
Row row = sheetRowsAddRow(RowIndex);
if (!dtColumnsContains(ColStructColumnName))
{
continue;
}
Cell cell = null;
if (rowCellExists(ColumnIndex))
{
cell = rowGetCell(ColumnIndex);
}
else
{
cell = sheetCellsAdd(RowIndex, ColumnIndex, null);
//rowAddCell(cell);
}
cellValue = ColStructColumnCaption;
cellFontWeight = FontWeightBold;
cellHorizontalAlignment = HorizontalAlignmentsCentered;
cellBottomLineStyle = 2;
cellBottomLineColor = ColorsGrey;
cellFontHeight = 10 20;
cellVerticalAlignment = VerticalAlignmentsCentered;
ushort ColumnMaxLength = GetColumnValueMaxLength(dt, ColStruct);
//设定列宽为自适应宽度
ColumnInfo colInfo = new ColumnInfo(xls, sheet);//生成列格式对象
//设定colInfo格式的起作用的列为第1列到第5列(列格式为0-base)
colInfoColumnIndexStart = (ushort)(ColumnIndex-1);
colInfoColumnIndexEnd = colInfoColumnIndexStart;
colInfoWidth = (ushort)(ColumnMaxLength 256);//列的宽度计量单位为 1/256 字符宽
sheetAddColumnInfo(colInfo);//把格式附加到sheet页上（注：AddColumnInfo方法有点小问题，不能把colInfo对象多次附给sheet页）
ColumnIndex++;
}
for (ushort i = 0; i < dtRowsCount; i++)
{
ushort RowIndex = (ushort)(i + 2);
Row row = sheetRowsAddRow(RowIndex);
int j = 0;
foreach (ColumnStruct ColStruct in TableInfoColumnInfoAry)
{
if ( !dtColumnsContains(ColStructColumnName) )
{
continue;
}
ColumnIndex = (ushort)(j + 1);
Cell cell = null;
if (rowCellExists(ColumnIndex))
{
cell = rowGetCell(ColumnIndex);
}
else
{
cell = sheetCellsAdd(RowIndex, ColumnIndex, null);
//rowAddCell(cell);
}
object objValue = dtRows[i][ColStructColumnName];
cellValue = GetColumnValueFormat(dt,ColStruct,objValue);
cellFontWeight = FontWeightNormal;
cellHorizontalAlignment = HorizontalAlignmentsCentered;
j++;
}
}
}
xlsSend();
}
private static string GetColumnValueFormat(DataTable dt, ColumnStruct ColStruct, Object ObjValue)
{
string ColumnValue = stringEmpty;
if ( ObjValue != null && ObjValue!= DBNullValue )
{
string ColumnDataType = dtColumns[ColStructColumnName]DataTypeToString();
switch (ColumnDataType)
{
case "SystemBoolean":
case "SystemByte":
{
ColumnValue = ObjValueToString();
break;
}
case "SystemDecimal":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToDecimal(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToDecimal(ObjValue)ToString(ColStructColumnTextFormat);
}
break;
}
case "SystemDouble":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToDouble(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToDouble(ObjValue)ToString(ColStructColumnTextFormat);
}
break;
}
case "SystemInt64":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToInt64(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToInt64(ObjValue)ToString(ColStructColumnTextFormat);
}
break;
}
case "SystemInt16":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToInt16(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToInt16(ObjValue)ToString(ColStructColumnTextFormat);
}
break;
}
case "SystemInt32":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToInt32(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToInt32(ObjValue)ToString(ColStructColumnTextFormat);
}
break;
}
case "SystemDateTime":
{
if (stringIsNullOrEmpty(ColStructColumnTextFormat))
{
ColumnValue = ConvertToDateTime(ObjValue)ToString();
}
else
{
ColumnValue = ConvertToDateTime(ObjValue)ToString(ColStructColumnTextFormat,SystemGlobalizationDateTimeFormatInfoInvariantInfo);
}
break;
}
default:
{
ColumnValue = ObjValueToString();
break;
}
}
}
return ColumnValueTrim();
}
private static ushort GetColumnValueMaxLength(DataTable dt, ColumnStruct ColStruct)
{
ushort InitLenth = (ushort)SystemTextEncodingDefaultGetByteCount(ColStructColumnCaption);
ushort MaxLenth = InitLenth;
foreach (DataRow Row in dtRows)
{
object ObjValue = Row[ColStructColumnName];
if (ObjValue == null || ObjValue == DBNullValue)
{
continue;
}
string ColumnValue = GetColumnValueFormat(dt,ColStruct,ObjValue);
ushort ColumnValueLenth = (ushort)SystemTextEncodingDefaultGetByteCount(ColumnValue);
MaxLenth = ColumnValueLenth > MaxLenth ColumnValueLenth : MaxLenth;
}
if (MaxLenth == InitLenth)
{
//标题栏字体较大
MaxLenth += 4;
}
else
{
//内容文本前后与边框空余出一字的间隔
MaxLenth += 2;
}
return (ushort)(MaxLenth 12);
}
}
页面调用ExcelHelper类中的静态方法ExportDataToExcel导出数据集中指定Table的制定列到Excel文件并输出文件到浏览器客户端。XmlManagerGetString是多语言实现的相关方法，可以直接修改为返回当前列标题字符串。
private void ExportDataToExcel(DSSummary_DetailsQuery_SellInfo ds)
{
SystemCollectionsGenericList<ExcelHelperTableStruct> TableInfoAry = new SystemCollectionsGenericList<ExcelHelperTableStruct>();
ExcelHelperTableStruct TableInfo = new ExcelHelperTableStruct();
TableInfoTableName = dsDS_StockTableName;
TableInfoTableCaption = XmlManagerGetString("Summary_DetailsQuery_ViewCarInfoCustormerDetail_TitleTxt");
ExcelHelperColumnStruct ColStruct = new ExcelHelperColumnStruct();
ColStructColumnName = "C_CarNo";
ColStructColumnTextFormat = stringEmpty;
ColStructColumnCaption = XmlManagerGetString("IAMS_System_CarInfo_CarNo");
TableInfoAddColumnInfo(ColStruct);
//……添加其他列信息
TableInfoAryAdd(TableInfo);
ExcelHelperExportToExcel(ds, TableInfoAry);
}
希望可以帮到你，有什么问题可以联系我。Email:wangminghu2000@163com

---