ɥozɐʞıɥ

2004-02-25 絎?

_ ICU

＞怨罔≧綽障

_ 紊篌ぞ

[ツッコミを入れる]

2005-02-25 眠れん！

_ [Office] OpenOffice 1.1.4

インストール。

ビバ！160GB。まだDiskの10%位しか使っていない。

#USB Diskに10GB位のデータがあるのをなんとかせねば。

_ [.NET] Web フォームユーザーコントロール

これを参考。

_ [.NET][XML] .NETで簡単XML

XMLづいています。

[ツッコミを入れる]

2006-02-25 ためておいたC#ネタ

_ [.NET][本][物欲] Essential .NET — 共通言語ランタイムの本質

これは色々よさげ

_ [.NET][C#][本][物欲] Visual C#.NETによるWebプログラミング入門—XML WebサービスとWebアプリケーション構築のノウハウ

ちょっと古いけど、立読みレヴェルではＯＫっぽい。

_ [C#][.NET] C#/ASP.NETでExcelを動的に作成する方法。(ファイルダウンロード)

Excel2003以降が対象です。XMLに吐き出せば、オートメーション使わなくっても大丈夫っぽい。


XmlDocument doc = new XmlDocument();
XmlDeclaration decl = doc.CreateXmlDeclaration("1.0","Shift_JIS","");
doc.AppendChild(decl);
XmlProcessingInstruction process = doc.CreateProcessingInstruction("mso-application","progid=\"Excel.Sheet\"");
doc.AppendChild(process);
XmlElement workbook = doc.CreateElement("Workbook");
workbook.SetAttribute("xmlns","urn:schemas-microsoft-com:office:spreadsheet");
workbook.SetAttribute("xmlns:o","urn:schemas-microsoft-com:office:office");
workbook.SetAttribute("xmlns:x","urn:schemas-microsoft-com:office:excel");
workbook.SetAttribute("xmlns:ss","urn:schemas-microsoft-com:office:spreadsheet");
workbook.SetAttribute("xmlns:html","http://www.w3.org/TR/REC-html40");
XmlElement styles = doc.CreateElement("Styles");
XmlElement style = doc.CreateElement("Style");
style.SetAttribute("ID","urn:schemas-microsoft-com:office:spreadsheet","Default");
style.SetAttribute("Name","urn:schemas-microsoft-com:office:spreadsheet","Normal");
XmlElement alignment = doc.CreateElement("Alignment");
alignment.SetAttribute("Vertical","urn:schemas-microsoft-com:office:spreadsheet","Center");
style.AppendChild(alignment);
style.AppendChild(doc.CreateElement("Borders"));
XmlElement font = doc.CreateElement("Font");
font.SetAttribute("FontName","urn:schemas-microsoft-com:office:spreadsheet","ＭＳ　ゴシック");
font.SetAttribute("CharSet","urn:schemas-microsoft-com:office:excel","128");
font.SetAttribute("Family","urn:schemas-microsoft-com:office:excel","Modern");
font.SetAttribute("Size","urn:schemas-microsoft-com:office:spreadsheet","11");
font.SetAttribute("Color","urn:schemas-microsoft-com:office:spreadsheet","#FF0000");
style.AppendChild(font);
style.AppendChild(doc.CreateElement("Interior"));
style.AppendChild(doc.CreateElement("NumberFormat"));
style.AppendChild(doc.CreateElement("Protection"));
styles.AppendChild(style);
style = doc.CreateElement("Style");
style.SetAttribute("ID","urn:schemas-microsoft-com:office:spreadsheet","s21");
XmlElement numberFormat = doc.CreateElement("NumberFormat");
numberFormat.SetAttribute("Format","urn:schemas-microsoft-com:office:spreadsheet","@");
style.AppendChild(numberFormat);
styles.AppendChild(style);
workbook.AppendChild(styles);
XmlElement worksheet = doc.CreateElement("Worksheet");
worksheet.SetAttribute("Name","urn:schemas-microsoft-com:office:spreadsheet","Sheet1");
XmlElement table = doc.CreateElement("Table");
table.SetAttribute("ExpandedColumnCount","urn:schemas-microsoft-com:office:spreadsheet","3");
table.SetAttribute("ExpandedRowCount","urn:schemas-microsoft-com:office:spreadsheet","2");
table.SetAttribute("FullColumns","urn:schemas-microsoft-com:office:excel","1");
table.SetAttribute("FullRows","urn:schemas-microsoft-com:office:excel","1");
table.SetAttribute("StyleID","urn:schemas-microsoft-com:office:spreadsheet","s21");
table.SetAttribute("DefaultColumnWidth","urn:schemas-microsoft-com:office:spreadsheet","54");
table.SetAttribute("DefaultRowHeight","urn:schemas-microsoft-com:office:spreadsheet","13.5");
for(int i = 0 ; i < 2 ; i++)
{
 XmlElement row = doc.CreateElement("Row");
 row.SetAttribute("ss:AutoFitHeight","0");
 for(int j = 0; j < 3 ; j++)
 {
   XmlElement cell = doc.CreateElement("Cell");
   XmlElement data = doc.CreateElement("Data");
   data.SetAttribute("Type","urn:schemas-microsoft-com:office:spreadsheet","String");
   data.InnerText = "日本語値";
   cell.AppendChild(data);
   row.AppendChild(cell);
 }
table.AppendChild(row);
}
worksheet.AppendChild(table);
workbook.AppendChild(worksheet);
doc.AppendChild(workbook);
Response.Cache.SetCacheability(HttpCacheability.Private);
Response.ContentType="application/vnd.ms-excel";
string name = System.Web.HttpUtility.UrlEncode("ファイル名.xls");
Response.AddHeader("content-disposition","attachment;filename="+name);
doc.Save(Response.OutputStream);
Response.End();

因みにCSVとして吐き出すなら…


string str = "a,b,c\nd,e,f";
Response.Cache.SetCacheability(HttpCacheability.Private);
Response.ContentType="application/vnd.ms-excel";
string name = System.Web.HttpUtility.UrlEncode("ファイル名.csv");
Response.AddHeader("content-disposition","attachment;filename="+name);
using (MemoryStream ms = new MemoryStream())
{
 using(StreamWriter sw = new StreamWriter(ms,System.Text.Encoding.GetEncoding("Shift_JIS")))
 {
  sw.Write(str);
  sw.Close();
 }
Response.BinaryWrite(ms.ToArray());
Response.End();
ms.Close();
}