![]() ![]() To do this, we’ll be using ExcelDataReader and ExcelDataReader.DataSet to decode Excel files into a DataSet. The game plan is simple, receive a HTTP request with the file we need to convert, check it’s validity, convert into a DataSet (allowing extensibility for multiple output formats, in the future) and perform the conversion to JSON. And yes, you can CI/CD with Azure Functions. ![]() I recommend using this method, since it will create all the files needed for the project, create the function on Azure and directly integrate your environment for deployment. You can create your first function using a template, emulate the testing environment directly from your machine and much more. VS Code and Azure FunctionsĪs good as this already was, Visual Studio Code has an amazing extension for Azure Functions. You can use it to convert data from different data sources for your next Data Science project or even as a simple CRUD based on Excel files, converting it after the user changes something to a more developer friendly format. csv file, and outputs it as a JSON string. This project aims at creating a simple function that receives an Excel file (. To get started on it, there’s pretty extensive documentation and training material to help you on at Azure on Microsoft Learn | Microsoft Docs.Īfter you’ve read a little about Azure Functions and how to use it, let’s get into the coding. Just code your business logic and you’re pretty much good to go. TL DR If you’re looking for the source code, go to the bottom of this article into the GitHub repository.Īzure Functions is a serverless solution from Microsoft that allows developers to build solutions incredibly quickly and without worrying about the overhead of creating a full application. This is a story about how you can use Azure Functions to easily convert an Excel or CSV to JSON leveraging the power of cloud computing and without the hassle of maintaining a Web API for this. Converting Excel files to JSON using C# and Azure Functions ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |