private static Uri ProcessExcelDocument( string fullFileName )
{
string tempFile = string.Format( "{0}\\{1}.html",
Environment.GetFolderPath( Environment.SpecialFolder.InternetCache ),
Guid.NewGuid() );
object oMissing = Missing.Value;
object oReadOnly = true;
object oFileType = XlFileFormat.xlHtml;
CultureInfo saveCulture = Thread.CurrentThread.CurrentCulture;
Microsoft.Office.Interop.Excel.Application application = null;
try
{
Thread.CurrentThread.CurrentCulture = new CultureInfo( "en-US" );
application = new Microsoft.Office.Interop.Excel.Application();
Workbook document = application.Workbooks.Open( fullFileName, oMissing, oReadOnly, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing );
if (document != null)
{
document.SaveAs( tempFile, //File Name
oFileType, //File Format
oMissing, //Password
oMissing, //Write Res Password
oMissing, //ReadOnly Recommended
oMissing, //Create Backup
XlSaveAsAccessMode.xlExclusive, //AccessMode
oMissing, //Conflict Resolution
oMissing, //Add To MRU
oMissing, //Text Codepage
oMissing, //Text Visual Layout
oMissing //Local
);
}
}
finally
{
if (application != null)
application.Quit();
Thread.CurrentThread.CurrentCulture = saveCulture;
}
return new Uri( tempFile );
}