各位大侠。我想实现把艺术字体用程序直接填写到excel的c5这个单元格内,该怎样写?
我的代码如下
Excel.Range rng;
rng = mysheet.get_Range( "$C$5",Type.Missing);
rng.Activate();
//v_Pictures.Insert( "C:\\123.jpg",Type.Missing).Select(rng);
mysheet.Shapes.AddTextEffect(Microsoft.Office.Core.MsoPresetTextEffect.msoTextEffect1,"hhj","宋体",11,Microsoft.Office.Core.MsoTriState.msoFalse,Microsoft.Office.Core.MsoTriState.msoFalse, float.Parse("0"), float.Parse("0")).Select(rng);
每次显示都是在excel的顶部,我该怎样写才能把它定位到c5这个单元格内显示。谢谢
我的代码如下
Excel.Range rng;
rng = mysheet.get_Range( "$C$5",Type.Missing);
rng.Activate();
//v_Pictures.Insert( "C:\\123.jpg",Type.Missing).Select(rng);
mysheet.Shapes.AddTextEffect(Microsoft.Office.Core.MsoPresetTextEffect.msoTextEffect1,"hhj","宋体",11,Microsoft.Office.Core.MsoTriState.msoFalse,Microsoft.Office.Core.MsoTriState.msoFalse, float.Parse("0"), float.Parse("0")).Select(rng);
每次显示都是在excel的顶部,我该怎样写才能把它定位到c5这个单元格内显示。谢谢
/// 根据模板生成Excel文档
/// </summary>
/// <param name="str"></param>
public static void SetExecl(string[] str)
{
ExcelFile ef = new ExcelFile(); string path = System.AppDomain.CurrentDomain.BaseDirectory; ef.LoadXls(path + "Generate FX Blotter Summary File.xls"); FillInvoiceData(ef.Worksheets[0], str); string fileName = "FX Blotter" + Convert.ToDateTime(str[0]).ToString("yyyyMMdd") + " _Detail.xls"; ef.SaveXls(fileName); TryToDisplayGeneratedFile(fileName);
} /// <summary>
/// 利用现有Excel模板,生成Excel文档
/// </summary>
/// <param name="ws"></param>
static void FillInvoiceData(ExcelWorksheet ws, string[] str)
{
ws.Cells["K2"].Value = str[0];
ws.Cells["F3"].Value = str[1]; DataTable table = MutualFundHelper.Get_SerchGenerateFXToExcel();
for (int i = 0; i < table.Rows.Count; i++)
{
ws.Cells[5 + i, 0].Value = table.Rows[i].ItemArray[0];
ws.Cells[5 + i, 1].Value = table.Rows[i].ItemArray[1];
ws.Cells[5 + i, 2].Value = table.Rows[i].ItemArray[2];
ws.Cells[5 + i, 3].Value = table.Rows[i].ItemArray[3];
ws.Cells[5 + i, 4].Value = table.Rows[i].ItemArray[4];
ws.Cells[5 + i, 5].Value = table.Rows[i].ItemArray[5];
ws.Cells[5 + i, 6].Value = table.Rows[i].ItemArray[6];
ws.Cells[5 + i, 7].Value = table.Rows[i].ItemArray[7];
ws.Cells[5 + i, 8].Value = table.Rows[i].ItemArray[8];
ws.Cells[5 + i, 8].Value = table.Rows[i].ItemArray[9];
ws.Cells[5 + i, 8].Value = table.Rows[i].ItemArray[10];
}
} static void TryToDisplayGeneratedFile(string fileName)
{
try
{
System.Diagnostics.Process.Start(fileName);
}
catch (Exception)
{
Console.WriteLine(fileName + " created in application folder.");
}
}
它根本不是在单元格内,而是与你写的 float.Parse("0"), float.Parse("0"))有关。另外,何必写“Parse”?直接写一个整数(或者浮点数)就行了。