static void Main(string[] args)
{
//foreach (string file in Directory.EnumerateFiles(@"C:\Users\yanswong\source\repos\Convert PDF file to Excel file\C#\SW\", "*.pdf"))
foreach (string file in Directory.EnumerateFiles(@"C:\Users\yanswong\Desktop\CMM\May-2017\", "*.pdf", SearchOption.AllDirectories))
//foreach (string [] file in Directory.GetDirectories(@"\\pngnas2.mys.agilent.com\EUC_Gshare\vpdpenang\VPD LDA\VPD LDA\CMM MEASUREMENT RESULT\2018\","*",SearchOption.AllDirectories))
{
//string pathToPdf = @"C:\Users\yanswong\source\repos\Convert PDF file to Excel file\C#\SW\3700391-115-01-18-2.pdf";
//string pathToExcel = Path.ChangeExtension(pathToPdf, ".xls");
string pathToExcel = Path.ChangeExtension(file, ".xls");
// Convert PDF file to Excel file
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
// 'true' = Convert all data to spreadsheet (tabular and even textual).
// 'false' = Skip textual data and convert only tabular (tables) data.
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
// 'true' = Preserve original page layout.
// 'false' = Place tables before text.
f.ExcelOptions.PreservePageLayout = true;
//f.OpenPdf(pathToPdf);
f.OpenPdf(file);
if (f.PageCount > 0)
{
int result = f.ToExcel(pathToExcel);
//Open a produced Excel workbook
//if (result==0)
//{
// System.Diagnostics.Process.Start(pathToExcel);
//}
}
}
}
static void Main(string[] args)
{
string pathToPdf = @"d:\Tempos\Table.pdf";
string pathToExcel = Path.ChangeExtension(pathToPdf, ".xls");
// Convert PDF file to Excel file
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
// 'true' = Convert all data to spreadsheet (tabular and even textual).
// 'false' = Skip textual data and convert only tabular (tables) data.
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
// 'true' = Preserve original page layout.
// 'false' = Place tables before text.
f.ExcelOptions.PreservePageLayout = true;
f.OpenPdf(pathToPdf);
if (f.PageCount > 0)
{
int result = f.ToExcel(pathToExcel);
//Open a produced Excel workbook
if (result == 0)
{
System.Diagnostics.Process.Start(pathToExcel);
}
}
}
public static void ConvertToExcel(object targ)
{
TArgument targum = (TArgument)targ;
string pdfFile = targum.PdfFile;
int page = targum.PageNumber;
string excelFile = Path.GetFileNameWithoutExtension(pdfFile) + ".xls";
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
// 'true' = Convert all data to spreadsheet (tabular and even textual).
// 'false' = Skip textual data and convert only tabular (tables) data.
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
// 'true' = Preserve original page layout.
// 'false' = Place tables before text.
f.ExcelOptions.PreservePageLayout = true;
// The information includes the names for the culture, the writing system,
// the calendar used, the sort order of strings, and formatting for dates and numbers.
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US");
ci.NumberFormat.NumberDecimalSeparator = ",";
ci.NumberFormat.NumberGroupSeparator = ".";
f.ExcelOptions.CultureInfo = ci;
f.OpenPdf(pdfFile);
bool done = false;
if (f.PageCount > 0)
{
if (page >= f.PageCount)
{
page = 1;
}
if (f.ToExcel(excelFile, page, page) == 0)
{
done = true;
}
f.ClosePdf();
}
if (done)
{
Console.WriteLine("{0}\t - Done!", Path.GetFileName(pdfFile));
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(excelFile)
{
UseShellExecute = true
});
}
else
{
Console.WriteLine("{0}\t - Error!", Path.GetFileName(pdfFile));
}
}
public static void ConvertToExcel(object targ)
{
TArgument targum = (TArgument)targ;
string pdfFile = targum.PdfFile;
int page = targum.PageNumber;
string excelFile = Path.ChangeExtension(pdfFile, ".xls");
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
// 'true' = Convert all data to spreadsheet (tabular and even textual).
// 'false' = Skip textual data and convert only tabular (tables) data.
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
// 'true' = Preserve original page layout.
// 'false' = Place tables before text.
f.ExcelOptions.PreservePageLayout = true;
f.OpenPdf(pdfFile);
bool done = false;
if (f.PageCount > 0)
{
if (page >= f.PageCount)
{
page = 1;
}
if (f.ToExcel(excelFile, page, page) == 0)
{
done = true;
}
f.ClosePdf();
}
if (done)
{
Console.WriteLine("{0}\t - Done!", Path.GetFileName(pdfFile));
}
else
{
Console.WriteLine("{0}\t - Error!", Path.GetFileName(pdfFile));
}
}
private void btnPDF2Excel_Click(object sender, EventArgs e) // PDF convert to Excel Function
{
SautinSoft.PdfFocus excel = new SautinSoft.PdfFocus(); // 呼叫SautinSoft中的Excel Convert Function
excel.OpenPdf(@"C:\Users\施宗佑\OneDrive\桌面\期末報告 - 物件導向程式設計\測試用文檔\Order.pdf");
excel.ToExcel(@"C:\Users\施宗佑\OneDrive\桌面\期末報告 - 物件導向程式設計\NewOrder.xls");
}
/// <summary>
/// Converts PDF to DOCX, RTF, HTML, XML, Excel (XLS), PNG, Multipage TIFF, Text.
/// </summary>
public static void ConvertPdfToAll()
{
SautinSoft.PdfFocus f = new SautinSoft.PdfFocus();
string pdfFile = @"..\..\..\..\simple text.pdf";
string outFile = String.Empty;
f.OpenPdf(pdfFile);
if (f.PageCount > 0)
{
// To Docx.
outFile = Path.ChangeExtension(pdfFile, ".docx");
f.WordOptions.Format = PdfFocus.CWordOptions.eWordDocument.Docx;
if (f.ToWord(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To Rtf.
outFile = Path.ChangeExtension(pdfFile, ".rtf");
f.WordOptions.Format = PdfFocus.CWordOptions.eWordDocument.Rtf;
if (f.ToWord(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To Excel.
outFile = Path.ChangeExtension(pdfFile, ".xls");
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
if (f.ToExcel(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To HTML.
outFile = Path.ChangeExtension(pdfFile, ".html");
f.ExcelOptions.ConvertNonTabularDataToSpreadsheet = true;
if (f.ToHtml(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To XML.
outFile = Path.ChangeExtension(pdfFile, ".xml");
f.XmlOptions.ConvertNonTabularDataToSpreadsheet = true;
if (f.ToXml(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To Image.
outFile = Path.ChangeExtension(pdfFile, ".png");
f.ImageOptions.Dpi = 300;
f.ImageOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Png;
if (f.ToImage(outFile, 1) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To Multipage Tiff (Black & White).
outFile = Path.ChangeExtension(pdfFile, ".tiff");
f.ImageOptions.ColorDepth = PdfFocus.CImageOptions.eColorDepth.BlackWhite1bpp;
if (f.ToMultipageTiff(outFile, System.Drawing.Imaging.EncoderValue.CompressionCCITT4) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
// To Text.
outFile = Path.ChangeExtension(pdfFile, ".txt");
if (f.ToText(outFile) == 0)
{
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile)
{
UseShellExecute = true
});
}
}
else
{
Console.WriteLine("Error: {0}!", f.Exception.Message);
Console.ReadLine();
}
}
