Free, open-source file converter. Convert 263 formats offline by drag & drop — images, PDF, Word, Excel, PowerPoint, HWP/HWPX, video, audio, e-books and archives. No upload, no Office needed.
C# audio-converteravaloniabatch-conversionconvertercsharpdocument-converterdocx-to-pdfdotnetdrag-and-dropfile-conversionfile-converterheic-converterhwphwpximage-converterlinuxmacospdf-convertervideo-converterwindows
// PDF → XLSX (#267): each table drawn with lines on its own sheet, with numbers and dates as real values, merged
// cells and column widths, a table going on over the next page joined, and a clear failure when there is no table.
using Filee.Core.Conversion;
using Filee.Core.Presets;
using Filee.Engines.Office.Sheets;
using Filee.Engines.Pdf;
namespace Filee.Engines.Tests;
public class PdfTablesTests(EngineFixture fx) : IClassFixture<EngineFixture>
{
/// <summary>A grid of rules with text in its cells; a null cell is covered by the one to its left (no rule between).</summary>
private static void Table(PdfBuilder pdf, double top, double[] xs, string?[][] rows, bool boldHeader = true)
{
var y = top;
foreach (var row in rows)
{
pdf.Rule(xs[0], y, xs[^1], y);
for (var c = 0; c < row.Length; c++)
{
if (c == 0 || row[c] is not null)
pdf.Rule(xs[c], y, xs[c], y + 20);
if (row[c] is { } text)
pdf.Line(text, 10, pdf.Font(bold: boldHeader && y == top), xs[c] + 4, y + 14);
}
pdf.Rule(xs[^1], y, xs[^1], y + 20);
y += 20;
}
pdf.Rule(xs[0], y, xs[^1], y);
}
private async Task<Workbook> ConvertAsync(string pdf)
{
var job = await fx.ConvertAsync([pdf], new Preset { TargetFormat = "xlsx" });
Assert.True(job.State == JobState.Completed, string.Join("; ", job.Files.Select(f => $"{f.ErrorKey} {f.ErrorDetail}")));
return XlsxReader.Read(job.Outputs.Single());
}
[Fact]
public async Task Numbers_dates_and_merged_cells_reach_the_sheet()
{
var pdf = new PdfBuilder().NewPage();
pdf.Paragraph("Sales by quarter, as reported.", 11, pdf.Font(), 50, 80, 495, 14);
Table(pdf, 110, [50, 200, 350, 545],
[
["Item", "Amount", "Date"],
["Paper", "1,234.50", "2026-10-23"],
["Ink", "(120)", "2026/1/5"],
["Share", "12.5%", "007"],
["Total for the year", null, "$9.99"],
]);
var book = await ConvertAsync(pdf.Save(Path.Combine(fx.NewFolder(), "sales.pdf")));
var sheet = Assert.Single(book.Sheets);
Assert.Equal("Item", sheet.Get(0, 0)!.Text);
Assert.Equal((1234.5, "#,##0.00"), (sheet.Get(1, 1)!.Value!.Value, sheet.Get(1, 1)!.NumberFormat));
Assert.Equal(-120, sheet.Get(2, 1)!.Value);
Assert.Equal(0.125, sheet.Get(3, 1)!.Value!.Value, 9);
Assert.Equal(new DateOnly(2026, 10, 23).DayNumber - new DateOnly(1899, 12, 30).DayNumber, sheet.Get(1, 2)!.Value);
Assert.Equal(new DateOnly(2026, 1, 5).DayNumber - new DateOnly(1899, 12, 30).DayNumber, sheet.Get(2, 2)!.Value);
Assert.Null(sheet.Get(3, 2)!.Value); // a code with a leading zero stays text
Assert.Equal("007", sheet.Get(3, 2)!.Text);
Assert.Equal(9.99, sheet.Get(4, 2)!.Value);
Assert.Contains(new CellRange(4, 0, 4, 1), sheet.Merges);
Assert.Null(sheet.Get(0, 0)!.Value); // the paragraph above the table isn't on the sheet
Assert.DoesNotContain(sheet.Rows.Values.SelectMany(r => r.Values), c => c.Text.Contains("Sales by quarter"));
// Column widths follow the PDF: the last column is the widest.
Assert.True(sheet.ColumnWidth(2) > sheet.ColumnWidth(0));
}
[Fact]
public async Task A_table_going_on_over_the_next_page_is_one_sheet_and_another_table_its_own()
{
double[] xs = [50, 250, 545];
var pdf = new PdfBuilder().NewPage();
Table(pdf, 600, xs, [["Name", "Size"], ["a.pdf", "10"], ["b.pdf", "20"]]);
pdf.NewPage();
Table(pdf, 60, xs, [["Name", "Size"], ["c.pdf", "30"]]); // header repeated on the new page
Table(pdf, 300, [50, 150, 300, 545], [["Code", "City", "Country"], ["SEL", "Seoul", "Korea"]]);
var book = await ConvertAsync(pdf.Save(Path.Combine(fx.NewFolder(), "files.pdf")));
Assert.Equal(2, book.Sheets.Count);
var files = book.Sheets[0];
Assert.Equal(["Name", "a.pdf", "b.pdf", "c.pdf"], Enumerable.Range(0, 4).Select(r => files.Get(r, 0)!.Text));
Assert.Equal(30, files.Get(3, 1)!.Value);
Assert.Null(files.Get(4, 0));
Assert.Equal("Seoul", book.Sheets[1].Get(1, 1)!.Text);
}
[Fact]
public async Task Text_between_two_tables_keeps_them_on_their_own_sheets()
{
double[] xs = [50, 250, 545];
var pdf = new PdfBuilder().NewPage();
Table(pdf, 60, xs, [["Name", "Size"], ["a.pdf", "10"]]);
pdf.Paragraph("These are this week's files. The next table lists the files kept from last week.", 11, pdf.Font(), 50, 200, 495, 14);
pdf.NewPage();
Table(pdf, 60, xs, [["Kept", "Days"], ["b.pdf", "7"]]);
var book = await ConvertAsync(pdf.Save(Path.Combine(fx.NewFolder(), "two.pdf")));
Assert.Equal(2, book.Sheets.Count);
Assert.Equal("Kept", book.Sheets[1].Get(0, 0)!.Text);
}
[Fact]
public void Only_a_pdf_reaches_a_spreadsheet_through_its_tables()
{
var planner = fx.Catalog.CreatePlanner();
// A picture made into a PDF has no ruled tables: no image → spreadsheet route through PDF, even with every
// optional engine installed.
var everything = fx.Catalog.CreatePlanner([.. fx.Catalog.All.Select(c => c.Id)]);
foreach (var image in new[] { "jpg", "png", "webp", "heic", "psd", "tiff" })
foreach (var target in new[] { "xlsx", "ods", "csv", "json" })
Assert.Null(everything.Plan(image, target));
foreach (var target in new[] { "xlsx", "ods", "csv" })
Assert.Equal("pdf-tables", Assert.Single(planner.Plan("pdf", target)!.Steps).Converter.Id);
}
[Fact]
public async Task Csv_and_ods_are_written_from_the_same_tables()
{
var pdf = new PdfBuilder().NewPage();
Table(pdf, 60, [50, 250, 545], [["Name", "Size"], ["a.pdf", "1,234"]]);
var path = pdf.Save(Path.Combine(fx.NewFolder(), "one.pdf"));
var csv = await fx.ConvertAsync([path], new Preset { TargetFormat = "csv" });
var ods = await fx.ConvertAsync([path], new Preset { TargetFormat = "ods" });
Assert.Equal(JobState.Completed, csv.State);
Assert.Contains("a.pdf", await File.ReadAllTextAsync(csv.Outputs.Single(), TestContext.Current.CancellationToken));
Assert.Equal(JobState.Completed, ods.State);
Assert.EndsWith(".ods", ods.Outputs.Single());
}
[Fact]
public async Task A_pdf_without_tables_fails_with_a_message()
{
var pdf = new PdfBuilder().NewPage();
pdf.Paragraph("Only a letter, no table here.", 11, pdf.Font(), 50, 80, 495, 14);
var job = await fx.ConvertAsync([pdf.Save(Path.Combine(fx.NewFolder(), "letter.pdf"))], new Preset { TargetFormat = "xlsx" });
Assert.Equal(JobState.Failed, job.State);
Assert.Equal("error.pdf_no_tables", job.Files[0].ErrorKey);
}
[Theory]
[InlineData("1,234", 1234d, "#,##0")]
[InlineData("-7", -7d, "0")]
[InlineData("0.5", 0.5, "0.0")]
[InlineData("€1,000.00", 1000d, "\"€\"#,##0.00")]
[InlineData("(1,200.50)", -1200.5, "#,##0.00;(#,##0.00)")]
[InlineData("50%", 0.5, "0%")]
public void Numbers_keep_their_shown_format(string text, double value, string format)
{
var number = PdfTablesConverter.Number(text);
Assert.NotNull(number);
Assert.Equal(value, number.Value.Value, 9);
Assert.Equal(format, number.Value.Format);
}
[Theory]
[InlineData("012")]
[InlineData("1,23")]
[InlineData("1.234,50")]
[InlineData("12 KB")]
[InlineData("(5")]
[InlineData("1234567890123456")]
[InlineData("10/23/2026")]
public void Other_text_stays_text(string text)
{
Assert.Null(PdfTablesConverter.Number(text));
Assert.Null(PdfTablesConverter.Date(text));
}
[Theory]
[InlineData("2026-10-23", "yyyy-mm-dd")]
[InlineData("2026/1/5", "yyyy/m/d")]
[InlineData("2026. 10. 23.", "yyyy. mm. dd.")]
public void Dates_with_the_year_first_become_dates(string text, string format)
{
var date = PdfTablesConverter.Date(text);
Assert.NotNull(date);
Assert.Equal(format, date.Value.Format);
Assert.Null(PdfTablesConverter.Date("2026-02-30")); // not a day
}
}