public void Test42726()
{
HPSFPropertiesExtractor ex = new HPSFPropertiesExtractor(HSSFTestDataSamples.OpenSampleWorkbook("42726.xls"));
String txt = ex.Text;
Assert.IsTrue(txt.IndexOf("PID_AUTHOR") != -1);
Assert.IsTrue(txt.IndexOf("PID_EDITTIME") != -1);
Assert.IsTrue(txt.IndexOf("PID_REVNUMBER") != -1);
Assert.IsTrue(txt.IndexOf("PID_THUMBNAIL") != -1);
}
public void TestCustomProperties()
{
POIFSFileSystem fs = new POIFSFileSystem(
_samples.OpenResourceAsStream("TestMickey.doc")
);
HPSFPropertiesExtractor ext = new HPSFPropertiesExtractor(fs);
// Custom properties are part of the document info stream
String dinfText = ext.DocumentSummaryInformationText;
Assert.IsTrue(dinfText.IndexOf("Client = sample client") > -1);
Assert.IsTrue(dinfText.IndexOf("Division = sample division") > -1);
String text = ext.Text;
Assert.IsTrue(text.IndexOf("Client = sample client") > -1);
Assert.IsTrue(text.IndexOf("Division = sample division") > -1);
}
public void Test52258()
{
POIFSFileSystem fs = new POIFSFileSystem(_samples.OpenResourceAsStream("TestVisioWithCodepage.vsd"));
HPSFPropertiesExtractor ext = new HPSFPropertiesExtractor(fs);
try
{
Assert.IsNotNull(ext.DocSummaryInformation);
Assert.IsNotNull(ext.DocumentSummaryInformationText);
Assert.IsNotNull(ext.SummaryInformation);
Assert.IsNotNull(ext.SummaryInformationText);
Assert.IsNotNull(ext.Text);
}
finally
{
ext.Close();
}
}
public void TestNormalUnicodeProperties()
{
POIFSFileSystem fs = new POIFSFileSystem(_samples.OpenResourceAsStream("TestUnicode.xls"));
HPSFPropertiesExtractor ext = new HPSFPropertiesExtractor(fs);
string text = ext.Text;
// Check each bit in turn
String sinfText = ext.SummaryInformationText;
String dinfText = ext.DocumentSummaryInformationText;
Assert.IsTrue(sinfText.IndexOf("AUTHOR = marshall") > -1);
Assert.IsTrue(sinfText.IndexOf("TITLE = Titel: \u00c4h") > -1);
Assert.IsTrue(dinfText.IndexOf("COMPANY = Schreiner") > -1);
Assert.IsTrue(dinfText.IndexOf("SCALE = False") > -1);
// Now overall
text = ext.Text;
Assert.IsTrue(text.IndexOf("AUTHOR = marshall") > -1);
Assert.IsTrue(text.IndexOf("TITLE = Titel: \u00c4h") > -1);
Assert.IsTrue(text.IndexOf("COMPANY = Schreiner") > -1);
Assert.IsTrue(text.IndexOf("SCALE = False") > -1);
}
public void TestNormalProperties()
{
POIFSFileSystem fs = new POIFSFileSystem(_samples.OpenResourceAsStream("TestMickey.doc"));
HPSFPropertiesExtractor ext = new HPSFPropertiesExtractor(fs);
String text = ext.Text;
// Check each bit in turn
String sinfText = ext.SummaryInformationText;
String dinfText = ext.DocumentSummaryInformationText;
Assert.IsTrue(sinfText.IndexOf("TEMPLATE = Normal") > -1);
Assert.IsTrue(sinfText.IndexOf("SUBJECT = sample subject") > -1);
Assert.IsTrue(dinfText.IndexOf("MANAGER = sample manager") > -1);
Assert.IsTrue(dinfText.IndexOf("COMPANY = sample company") > -1);
// Now overall
text = ext.Text;
Assert.IsTrue(text.IndexOf("TEMPLATE = Normal") > -1);
Assert.IsTrue(text.IndexOf("SUBJECT = sample subject") > -1);
Assert.IsTrue(text.IndexOf("MANAGER = sample manager") > -1);
Assert.IsTrue(text.IndexOf("COMPANY = sample company") > -1);
}
public void TestConstructors()
{
POIFSFileSystem fs;
HSSFWorkbook wb;
try
{
fs = new POIFSFileSystem(_samples.OpenResourceAsStream("TestUnicode.xls"));
wb = new HSSFWorkbook(fs);
}
catch (IOException e)
{
throw new Exception("TestConstructors", e);
}
ExcelExtractor excelExt = new ExcelExtractor(wb);
String fsText;
HPSFPropertiesExtractor fsExt = new HPSFPropertiesExtractor(fs);
fsExt.SetFilesystem(null); // Don't close re-used test resources!
try
{
fsText = fsExt.Text;
}
finally
{
fsExt.Close();
}
String hwText;
HPSFPropertiesExtractor hwExt = new HPSFPropertiesExtractor(wb);
hwExt.SetFilesystem(null); // Don't close re-used test resources!
try
{
hwText = hwExt.Text;
}
finally
{
hwExt.Close();
}
String eeText;
HPSFPropertiesExtractor eeExt = new HPSFPropertiesExtractor(excelExt);
eeExt.SetFilesystem(null); // Don't close re-used test resources!
try
{
eeText = eeExt.Text;
}
finally
{
eeExt.Close();
}
Assert.AreEqual(fsText, hwText);
Assert.AreEqual(fsText, eeText);
Assert.IsTrue(fsText.IndexOf("AUTHOR = marshall") > -1);
Assert.IsTrue(fsText.IndexOf("TITLE = Titel: \u00c4h") > -1);
// Finally tidy
wb.Close();
}
