public void GetFormatStringは指定したインデックスの書式を取得できる()
{
// setup
using (FileStream stream = new FileStream(getStylesPath(), FileMode.Open, FileAccess.Read))
{
XlsxStyles styles = new XlsxStyles(stream);
//expect
Assert.AreEqual("General", styles.GetFormatString(0));
Assert.AreEqual("m/d/yy", styles.GetFormatString(1));
Assert.AreEqual("#,##0.0000_ ", styles.GetFormatString(2));
}
}
public void GetFormatIdは指定したインデックスの書式IDを取得できる()
{
// setup
using (FileStream stream = new FileStream(getStylesPath(), FileMode.Open, FileAccess.Read))
{
XlsxStyles styles = new XlsxStyles(stream);
//expect
Assert.AreEqual(0, styles.GetFormatId(0));
Assert.AreEqual(14, styles.GetFormatId(1));
Assert.AreEqual(177, styles.GetFormatId(2));
}
}
private void ReadWorkbookInformation()
{
try
{
this.zipFile = ZipFile.Read(fileName);
using (Stream stream = GetInputStream("xl/workbook.xml")) { workbook = new XlsxWorkbook(stream); }
using (Stream stream = GetInputStream("xl/styles.xml")) { styles = new XlsxStyles(stream); }
using (Stream stream = GetInputStream("xl/sharedStrings.xml")) { sharedStrings = new XlsxSharedStrings(stream); }
}
finally
{
Close();
}
}
/// <summary>
/// <see cref="XlsxWorksheetHandler"/> を作成する。
/// </summary>
/// <param name="styles">書式情報</param>
/// <param name="sharedStrings">共有文字列情報</param>
/// <param name="xlsxCellParser">セル処理</param>
public XlsxWorksheetHandler(XlsxStyles styles, XlsxSharedStrings sharedStrings, XlsxCellParser xlsxCellParser)
{
this.styles = styles;
this.sharedStrings = sharedStrings;
this.cellParser = xlsxCellParser;
}
private void ReadWorkbookInformation()
{
try
{
this.zipFile = ZipFile.Read(fileName);
using (Stream stream = GetInputStream("xl/workbook.xml")) { workbook = new XlsxWorkbook(stream); }
using (Stream stream = GetInputStream("xl/styles.xml")) { styles = new XlsxStyles(stream); }
using (Stream stream = GetInputStream("xl/sharedStrings.xml")) { sharedStrings = new XlsxSharedStrings(stream); }
}
finally
{
Close();
}
}
/// <summary>
/// <see cref="XlsxWorksheetHandler"/> を作成する。
/// </summary>
/// <param name="styles">書式情報</param>
/// <param name="sharedStrings">共有文字列情報</param>
/// <param name="xlsxCellParser">セル処理</param>
public XlsxWorksheetHandler(XlsxStyles styles, XlsxSharedStrings sharedStrings, XlsxCellParser xlsxCellParser)
{
this.styles = styles;
this.sharedStrings = sharedStrings;
this.cellParser = xlsxCellParser;
}
