Pdf to Excel with C#

X-API-KEY: <apikey>

using System;
using System.Net.Http;
using System.Threading.Tasks;
using System.IO;

class Program
{
    static async Task Main()
    {
        var apiKey = "YOUR_API_KEY"; // Replace with your actual API key
        var filePath = "/path/to/your/file.pdf"; // Replace with the path to your PDF file
        var url = "https://app.pdfdodo.com/api/uploadfile"; // The API endpoint

        using (var httpClient = new HttpClient())
        {
            using (var form = new MultipartFormDataContent())
            {
                httpClient.DefaultRequestHeaders.Add("x-api-key", apiKey);

                // Assuming the file is on the disk, and we can open a read stream
                using (var fs = File.OpenRead(filePath))
                {
                    using (var streamContent = new StreamContent(fs))
                    {
                        using (var fileContent = new ByteArrayContent(await streamContent.ReadAsByteArrayAsync()))
                        {
                            fileContent.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("multipart/form-data");

                            // "file" is the name of the parameter for the file upload
                            form.Add(fileContent, "file", Path.GetFileName(filePath));

                            // Post the form to the URL
                            HttpResponseMessage response = await httpClient.PostAsync(url, form);

                            if (response.IsSuccessStatusCode)
                            {
                                Console.WriteLine("File uploaded successfully!");
                            }
                            else
                            {
                                Console.WriteLine("File upload failed!");
                            }

                            // Read the response content and output it to the console
                            string responseContent = await response.Content.ReadAsStringAsync();
                            Console.WriteLine(responseContent);
                        }
                    }
                }
            }
        }
    }
}

using System;
using System.Net.Http;
using System.Threading.Tasks;

class Program
{
    static async Task Main()
    {
        // Replace YOUR_API_KEY_HERE with your actual API key
        string apiKey = "YOUR_API_KEY_HERE";
        string documentId = "123e4567-e89b-12d3-a456-426614174000";
        string baseUri = "https://app.pdfdodo.com/api/analyze";
        string uri = $"{baseUri}?documentid={documentId}/results";

        using (var httpClient = new HttpClient())
        {
            // Add the API key to the request headers
            httpClient.DefaultRequestHeaders.Add("x-api-key", apiKey);
            httpClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));

            // Send the GET request
            var response = await httpClient.GetAsync(uri);

            // Ensure we get a success status code
            response.EnsureSuccessStatusCode();

            // Read the response content
            var responseContent = await response.Content.ReadAsStringAsync();
            Console.WriteLine(responseContent);
        }
    }
}

{
  "tables": [
    {
      "title": "The title of your table",
      "tableId": "a0f229f6-ade7-4637-bbff-e31fbbd64ec5",
      "pageNumber": 1,
      "rows": [
        [
          "0",
          "Money In ",
          "$1,880.00 "
        ],
        [
          "1",
          "Money Out ",
          "$150.25 "
        ],
        [
          "2",
          "You Received ",
          "$1,729.75 "
        ]
      ],
      "left": 0.6953286,
      "top": 0.2655254,
      "width": 0.2580709,
      "height": 0.11655326,
      "mergedTables": []
    }    
  ]
}

using Microsoft.Office.Interop.Excel;
using Newtonsoft.Json.Linq;
using _Excel = Microsoft.Office.Interop.Excel;

public void JsonToExcel(string jsonString)
{
    // Parse the JSON string
    JObject jsonObject = JObject.Parse(jsonString);

    // Start Excel and get Application object.
    var excelApp = new _Excel.Application();
    excelApp.Visible = true; // You can set this to false if you don't want the Excel window to be visible

    // Create a new, empty workbook and add a worksheet.
    _Excel.Workbook workbook = excelApp.Workbooks.Add(Type.Missing);
    _Excel.Worksheet worksheet = (_Excel.Worksheet)workbook.Worksheets[1];

    // Get the table rows from JSON
    JArray rows = (JArray)jsonObject["tables"][0]["rows"];

    // Iterate over each row and column to write the data to the sheet
    for (int i = 0; i < rows.Count; i++)
    {
        JArray row = (JArray)rows[i];
        for (int j = 0; j < row.Count; j++)
        {
            // Excel is 1-indexed
            worksheet.Cells[i + 1, j + 1] = row[j];
        }
    }

    // Save the workbook and Quit Excel
    workbook.SaveAs(@"C:\path\to\your\spreadsheet.xlsx");
    workbook.Close();
    excelApp.Quit();
}

using System;
using System.Collections.Generic;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using Newtonsoft.Json;

class Program
{
    static void Main(string[] args)
    {
        // Your JSON string
        string jsonString = @"{
          'tables': [
            {
              'title': 'The title of your table',
              'tableId': 'a0f229f6-ade7-4637-bbff-e31fbbd64ec5',
              'pageNumber': 1,
              'rows': [
                ['0', 'Money In', '$1,880.00'],
                ['1', 'Money Out', '$150.25'],
                ['2', 'You Received', '$1,729.75']
              ]
            }    
          ]
        }";

        // Deserialize the JSON string into a C# object
        var response = JsonConvert.DeserializeObject<JsonResponse>(jsonString);

        // Create a new Excel file
        string filePath = "output.xlsx";
        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook))
        {
            // Add a WorkbookPart to the document.
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
            workbookpart.Workbook = new Workbook();

            // Add a WorksheetPart to the WorkbookPart.
            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();
            worksheetPart.Worksheet = new Worksheet(new SheetData());

            // Add Sheets to the Workbook.
            Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets());

            // Append a new worksheet and associate it with the workbook.
            Sheet sheet = new Sheet()
            {
                Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart),
                SheetId = 1,
                Name = response.Tables[0].Title
            };
            sheets.Append(sheet);

            SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();

            // Add header row to the Excel file
            Row headerRow = new Row();
            headerRow.Append(
                new Cell() { CellValue = new CellValue("Id"), DataType = CellValues.String },
                new Cell() { CellValue = new CellValue("Description"), DataType = CellValues.String },
                new Cell() { CellValue = new CellValue("Amount"), DataType = CellValues.String }
            );
            sheetData.AppendChild(headerRow);

            // Add the data rows to the Excel file
            foreach (var rowData in response.Tables[0].Rows)
            {
                Row newRow = new Row();
                foreach (string cellValue in rowData)
                {
                    newRow.Append(new Cell() { CellValue = new CellValue(cellValue), DataType = CellValues.String });
                }
                sheetData.AppendChild(newRow);
            }

            workbookpart.Workbook.Save();
        }

        Console.WriteLine("Excel file created successfully!");
    }
}

// Define classes to match the JSON structure
public class JsonResponse
{
    public List<Table> Tables { get; set; }
}

public class Table
{
    public string Title { get; set; }
    public List<List<string>> Rows { get; set; }
}