Support for Spreadsheet (XLSX or XLS)

[Akashrajawat007]

Hi, I am creating a tool that can extract info from different file formats, and I've been successful with CSV and JSON files thanks to your library. But I am not able to figure out how to read data from Spreadsheets (XLSX/XLS), I've tried working with other libraries but was unsuccessful due to their different way of building (cmake or vcpkg).

I was searching on the web and somewhere I got this code snippet

#include <jsoncons/json.hpp>
#include <jsoncons_ext/spreadsheet/spreadsheet.hpp>
#include <fstream>

int main()
{
    std::string filename = "example.xlsx";

    // Open the XLSX file
    std::ifstream ifs(filename, std::ios::binary);
    jsoncons::spreadsheet::basic_ixlsx_input_archive<jsoncons::binary_input_adaptor> archive(ifs);

    // Convert the XLSX file to JSON
    jsoncons::ojson j = archive.read();

    // Print the resulting JSON object
    std::cout << pretty_print(j) << std::endl;

    return 0;
}

I am not able to find this Spreadsheet directory inside jsoncons_ext.

Can any suggest me how can I find it ? or is it there or not ?

[economicseries]

I vaguely recall jsoncons_ext/spreadsheet, it would have been a long time ago. It's not mentioned in the ChangeLog, I don't think it was part of any released version. It would have been based on a third party library to read from and write to the Excel files, I believe there were some problems with that library in supporting newer versions of Excel, and I decided it wasn't worth it. There are probably some remnants of it in github somewhere, but at this point I don't think they'd be very helpful.

Best regards,
Daniel

[Akashrajawat007]

Thankyou Daniel,
Actually I have gone through all documentation myself and haven't seen anything like that, It's actually was mentioned by Chat GPT when i asked which library I can use for reading spreadsheets, and that shocked me because I haven't seen it myself.
But in any case thankyou.