With this setting, users will be able to hide the time to remain focused, capture screen recordings without having to edit to hide time and date. Excel document package. Today, we are excited to share that our vision has become a reality using ONNX Runtime as the gateway to Windows AI and Olive, a toolchain we created to ease the burden on you when optimizing models for varied Windows and other devices. The easiest way to write data With a renewed focus on your productivity, we are announcing a new home for developers on Windows Dev Home. We continue to invest in important tools to democratize how apps will be built for the new era of AI; whether youre developing on x86/x64 or Arm64 we want to make it easy for you to bring AI powered experiences in Windows apps across cloud and edge. Christian builds software for the health industry and leads up a team. Thats nearly 10 times faster! The power you need to scrape & output clean, structured data. If you have your data in a collection then your best method is to write the data using a range. Have a question? After that, we need to convert our worksheet into a data table so that we can further load it into our Data Grid View. It uses EntityFramework to build the database and then export the data line by line. Windows Copilot will start to become available in preview for Windows 11 in June, stay tuned and sign up here to get updates from the team. Running my code below ran for nearly 20 minutes without completing before I canceled it ( I tried twice). The things you love about Windows copy/paste, Snap Assist, Snipping Tool, personalization they are all right there for you, along with every other feature on the platform, and they only get better with Windows Copilot. Interested in developing solutions that extend the Office experience across multiple platforms? Learn how to add Arm support for your apps. All rights reserved. You might be thinking that reading excel files would be difficult and require high-level expertise, but this is not the case. Tesseract 5 OCR in the languages you need, We support 127+. Go Professional to cover 10 developersand unlimited projects. Today, the team and I are excited to share the next steps we are taking on our journey with Windows 11, to meet this new age of AI. Today, we are announcing Dev Drive a new type of storage volume, tailor-made for developers, with a file system that delivers both performance and security. Note: Use ExcelFileFormat.XLS toi support legacy versions of Microsoft Excel (95 and earlier). The Excel API you need, without the Office Interop hassle. Obtain ranges by using the string indexer on a WorkSheet object. Output:if(typeof ez_ad_units!='undefined'){ez_ad_units.push([[250,250],'qawithexperts_com-large-mobile-banner-1','ezslot_9',133,'0','0'])};__ez_fad_position('div-gpt-ad-qawithexperts_com-large-mobile-banner-1-0'); As you can see we have used Interop to open and read excel rows/columns, one of the drawbacks of using MS office Interop is that you need it installed on Server also. You now can get improved performance of archive functionality during compression on Windows. megabytes. After reading the name from Row1Col1 , i need to fetch its id from oracle table. Use HDR=YES if first excel row contains headers, alternatively,use HDR=NO when your excel's first row is not headers and it's data. Access to the values of individual spreadsheet cells is carried out by retrieving the desired cell from its WorkSheet. If you can restrict it to just (Open Office XML format) *.xlsx files, then probably the most popular library would be EPPLus . Bonus is, there are ONNX Runtime makes it easier for you to create amazing AI experiences on Windows and other platforms, with less engineering effort and better performance. c. Code to Read data within a specific range This is never a good idea, and instantly disqualifies this as an option. I have the same Weather file saved as "Weather.csv", so I am using the same file for all the examples. This is an incredible time to be a developer on Windows. They can still re-publish the post if they are not suspended. Each WorkBook can have multiple WorkSheet objects. Select * from [Sheet1$], Now loop through each row of excel sheet and print it in Console app, If you are using ASP.NET, you can bind it with Grid View using below code instead of printing it, Now, we have discussed each step, suppose this is out Excel file. Add the SQLite Entity Framework NuGet packages. 8 contributors Feedback In this article Getting a SpreadsheetDocument Object Approaches to Parsing Open XML Files Sample Code See also This topic shows how to use the classes in the Open XML SDK 2.5 for Office to programmatically read a Chances are they have and don't get it. shows how to use the Open(String, Boolean) overload. 205 N. Michigan Ave. Chicago, IL 60611, USA, Reading .XLS and .XLSX Excel Files Using IronXL, 1. i have 4 columns and 3000 rows in my excel sheet. It does not require Microsoft Excel to be installed, and is not dependant on Interop. Use IronXL to export data to a database or convert an Excel spreadsheet to a database. If you dont renew the license, they cut off support, and youre left on your own. i have 4 columns and 3000 rows in my excel sheet. After your code executes, restore the functionality to i I will use the minimum design for the demonstration. the_lillith Better (efficient and faster) way to Read Excel data Hello. Contact us. After installing IronXL, go to your form and start designing it. Last year at Build, we announced Hybrid Loop, a new development pattern that enables hybrid AI scenarios across Azure and client devices. We welcome you to be part of the Windows Copilot journey by continuing to invest in Bing and ChatGPT plugins so your investments will carry forward to Windows Copilot. Its an exciting time to be a developer, even more so on Windows, and were thrilled to be on this journey with our you. IronXL facilitates reading and editing Microsoft Excel documents with C#. On the third line, we have selected the cell range within which we want to read the data. Let's look at how to do that. c. Directly download it and add a reference to the project, a. The first With our renewed focus on supercharging developer productivity, we believe Windows now provides the best platform for you to create cutting edge experiences for your customers and is also the best platform for you to reach those customers, all with minimal cost and effort. handles very large Excel spreadsheets. We can add the IronXL Package in one of any three ways, so you can choose the method that suits you best. For more information b. WebIf you selected the Share button, people will receive an email message inviting them to open the file. parameter takes a string that represents the full path to the document However, you can use other namespaces as per the requirements of your own projects. We cant wait to see what the Windows developer community will create with these new AI toolchains and NPU hardware advancements. If I want to call my family in Cyprus, I can quickly check the local time to make sure Im not waking them up in the middle of the night. It has never been easier to help all your RGB accessories seamlessly work together for Windows apps. Our design will look like the following: I need to read data like Row1col1 , Row1Col2 , Row1Col3 and Row1Col4. Its works really well to export data from excel sheets: http://exceldatareader.codeplex.com/ Unflagging mhamzap10 will restore default visibility to their posts. Today, many of these accessories rely on third-party apps and integrations that are highly fragmented. This is the information age, and many people store their data in excel files because they are user-friendly. The WorkBook class represents an Excel sheet. Now that we can read excel files using C#, let's explore some advanced options. Installing IronXL using the Manage Package Manager Let's open our "Weather.xlsx" file in Microsoft Excel and compare our output. The following code iterates through the countries and sets the Name, Population, Region, NumericCode, and Top 3 Languages in the spreadsheet. Today, were pleased to announce new AI-powered features, expanded Microsoft Store Ads and new tools to help you reach your customers: To learn more about what we announced in the Microsoft Store on Windows today, including new AI-powered experiences and developer tools, visit this blog post. Error: redirect_uri_mismatch - Google OAuth Authentication, how to generate dynamic url using .NET MVC, How to convert JSON String into C# class object, Cannot convert null to a value type JSON error, DbArithmeticExpression arguments must have a numeric common type. We are just starting to see the incredible impact AI is having across industries and in our own daily lives. Node 20.0.0 is available from April with native Arm support. Let's suppose that you want to read the data from an excel file for a specific cell range. In the Open XML SDK, the SpreadsheetDocument class represents an If you are just getting started with AI or if you are wondering where to start, Microsoft and Windows are here to help you on that journey. { We value community input on the experience, and we want to build this with you. Try to use Aspose.cells library (not free, but trial is enough to read), it is quite good Install-package Aspose.cells There is sample code: using Get in touch with our development team. We will be covering the following topics in this article: Adding IronXL Nuget Package to our Project, a. IronXL does not require Excel to be installed on your server or Interop. With a reference to Cell object, we can read and write data to and from a spreadsheet cell: The Range class represents a two-dimensional collection of Cell objects. Contribute and engage with us at the GitHub repository. We want to empower you to focus your time on creating and building writing code that only you can write. We cant wait to share more with you tomorrow during our Windows keynote, be sure to register for Build and tune in! Go to: Tools = > NuGet Package Manager => Manage NuGet Packages for Solution, and click on it. Thanks. /// /Reads an excel file and converts it into dataset with each sheet as each table of the da All instances of the app are ungrouped with labels on the taskbar. I have selected the range A1:C6 which means that it will read the first three columns: Column A, Column B, and Column C, as well as the first six rows, as shown below. Please view the text file saved on your desktop to get the agency names. Installing IronXL.Excel, is most easily achieved using our NuGet package, although you may also choose to manually install the DLL to your project or to your global assembly cache. The DataValidation sample uses libphonenumber-csharp to validate phone numbers and uses standard C# APIs to validate email addresses and dates. DEV Community A constructive and inclusive social network for software developers. Visual Studio 17.71 Preview 1 now ships with support for Linux development with C++. Designing the Form If you are a .Net Programmer and struggling with reading excel files, then don't worry you are in the right place. With C is better to access excel data transforming it to CSV file, and then access it as a TXT file. one element at a time, without having to load the entire file into It will become hidden in your post, but will still be visible via the comment's permalink. Now, we have to design the form to suit our requirements. Download the C# Library to read Excel files, Install the IronXL Excel Library. However, the DOM approach requires loading entire Open XML parts into After getting all the Id's of all the columns of the first row , i need to check in one of the oracle table for that match exists or not. To improve performance for VBA macros, explicitly turn off the functionality that is not required while your code executes. Your favorite tool, Windows Terminal is getting smarter with GitHub Copilot X. document is represented in the package as XML using SpreadsheetML markup. With the incredible momentum thats building around this new era of AI, we cant wait to see what you will create next. Go to: Tools = > NuGet Package Manager => Manage NuGet Packages for Solution, and click on it. Take a look at Linq-to-Excel . It's pretty neat. var book = new LinqToExcel.ExcelQueryFactory(@"File.xlsx"); Load an Excel Workbook. Now in the Build Menu you will be able to go to the Config Manager and set output to x86.). 30 day free trial test for development. The code will remain the same, we just have to change the file name to "Wather.xls" as shown below: WorkBook workbook = WorkBook.Load("Weather.xls"); If you have csv files instead of an excel file, you have to make slight changes to the code. The ExcelToDB sample reads a spreadsheet with GDP by country and then exports that data to an SQLite. Programmers must also know all about reading excel files in their respective programming language. In fact, IronXL provides a faster and more intuitive API than Microsoft.Office.Interop.Excel. To try them, you Consider using SAX when you need to handle very large files. as shown below: IronXL's Cell class represents an invidual cell in an Excel spreadsheet. For this, you would have to install EPPlus, so navigate to "Tools"-> "Nuget package manager"-> "Manage Nuget for this solution" -> Select "Browse" tab and search for "EPPlus", then install the nuget package. Windows 11 has the largest and most powerful ecosystem of GPUs in the world with more than 200M+ AI capable discrete GPUs. Our partners are continuing to innovate and deliver like Qualcomm with the Snapdragon 8cx Gen3 Compute Platform which today enables Windows devices including the Surface Pro 9 5G and the Windows Dev Kit 2023. What is the best and the simplest way for Reading from and writing to Excel files in C++?I'll appreciate if anybody can help me. I will show you a step-by-step for reading excel files using C#. This all was done with just a few lines of code. We're a place where coders share, stay up-to-date and grow their careers. Go to the ToolBox=> Select Label (for name our example app), and select the "Panel and Data" grid view. var startCell = ( Range )xlNewSheet.Cells [2, 1]; var endCell = new The content must be between 30 and 50000 characters. var query = Can anyone recommend a better wayto handle this? If I want to plan a trip to visit them in Cyprus, I can ask Windows Copilot to find my family flights and accommodations for mid-winter break. Let's look at the following example. You can now quickly identify and access any instance of each app housed in the taskbar with just one click. Output of the above code will be as below. If you use the exact match option, the calculation time for the function is proportional to the number of cell exception when you are working with really large files. Use a Function You Find. Were thrilled to introduce Windows Copilot. This is what the API JSON data looks like. This code creates a new sheet, specifies headers, and outputs the error message results so that there is a log of invalid data. AMD recently made early access of Ryzen AI software available to developers to run AI models on AMD Ryzen 7040 Series processors with Ryzen AI. spelling and grammar. First you will have to add reference for "Microsoft.Office.Interop.Excel", so in your Console, Windows or Web-Application, right-click on "Reference" and then in "Assemblies" search for "Microsoft.Office.Interop.Excel", So, here is the C# Code for it, considering we have sample XLSX file as above. Solution 1 : Search for a library that can enable you reading .xlsx file. Solution 2 : Write your own parser for .xlsx format. .xlsx is an op I will be using Windows Form App as an example, but you can use one of your choice, such as Asp.Net Web App, .Net core MVC or .Net Core web api. We can now load these files in 0.63 seconds. In addition, there are other tutorials which may shed light in other aspects of IronXL.Excel including Creating, Opening, Writing, Editing, Saving and Exporting XLS, XLSX and CSV files without using Excel Interop. In fact, one of the most exciting areas driving that growth for Windows has been developers themselves, with a 24% YoY increase in monthly devices used for development. Importing csv files in Python is 100x faster than Excel files. I tried on a smaller dataset (24 columns and 15 rows) and it worked with no problem so I guess for some reason my approach is just inefficient. Dev Home can also configure your coding environments in the cloud using Microsoft Dev Box and GitHub Codespaces. We can do this using our, In Visual Studio, right-click on the project select "Manage NuGet Packages ". If you want to learn more about Iron Software products, please click on this link. You can use ZetExcel.com for NET speeds up the spreadsheet processing and conversion tasks. IronXL.Excel is alone .NET software library for reading a wide variety of spreadsheet formats. You can do this on Dev Home. Dev Home is a new experience in Windows 11, memory. Dev home is open source. the DOM approach. Bring your apps to the Windows platform and leverage ONNX Runtime to deliver AI experiences like Camo. => Click on Next = > Select your Target Framework; I am selecting .Net core 3.1, but again, you can choose your own. With the right tools we can empower developers and our shared customers to shape the future and leave their mark on the world. ONNX Runtime now supports the same API for running models on the device or in the cloud, enabling hybrid inferencing scenarios where your app can use local resources when possible and switch to the cloud when needed. Most upvoted and relevant comments will be first, Software Engineer | .Net Core | EF Core | Web API | SQL Server, read excel in C# using Epplus or MS Interop, Convert PDF to Image in Java (Code Example Tutorial), Merge PDF Files in Java (Code Example Tutorial), Creating an Example Project for our Demonstration. Here is what you can do to flag mhamzap10: mhamzap10 consistently posts content that violates DEV Community's Download Data from an API to Spreadsheet, In Solution Explorer, right-click References, Manage NuGet Packages, Download and unzip IronXL to a location such as ~/Libs within your Solution directory, In Visual Studio Solution Explorer, right click References. The following code segment is used to read a very large Excel file using MS Interop requires a licensed copy of Office to be installed on the server. Select Browse, "IronXL.dll", Opening, Writing, Editing, Saving and Exporting, How to Read Excel File in C# on GitHub, Dedicated product support from our .NET engineers, Easy installation via Microsoft Visual Studio. The feature is located in the time and date settings page in Windows Settings. Often, one recalculation or one redraw after your code runs is all that is necessary and can improve performance. For more information, please click here. We know you often deal with repositories containing many thousands of files and directories, and historically this has presented a challenge for heavy I/O operations such as builds. Whether you are working on Windows or on Web or on Console application, at one stage we need to process data and excel file is widely used for it, so in previous article, we have explained about creating excel in C# without interop but in this article, I am going to provide you code to open and read excel file (.xls or .xlsx) in C# line by line in Console application using OLEDB or EPPlus or Interop (all 3 methods), you can use the same code C# code to fill ASP.NET GridView or MVC application table. Looking to add your own custom-built extensions? We are humbled to be on this journey with you. Thats an error. Christian has years of experience integrating with systems of all kinds. Step 1: Create a new Console applicaiton in your Visual Studio, by navigating to File->New->Project-> Select "Windows Classic dekstop" from left-pane & "Console-App" from right-pane -> Provide a name to your application "CSharpReadExcelFile" -> Click "OK". I know it was working bc I could see CPU and memory utilization plus I could hear the fan trying to cool everything down. Users of GitHub Copilot will be able to take advantage of natural language AI both inline and in an experimental chat experience to recommend commands, explain errors and take actions within the Terminal application. Once downloaded, just add the reference of the file in your project and start using it. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. method separately by commenting the call to the one you would like to Update, May 24, 2023: This blog post was updated to add additional detail on the AI library, Panos Panay, Chief Product Officer, Windows and Devices, be sure to register for Build and tune in, Join the GitHub Copilot Chat waitlist to gain access. Don't tell someone to read the manual. Try to use this free way to this, https://freenetexcel.codeplex.com Workbook workbook = new Workbook(); Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly, Site design/Logo 2023 - Qawithexperts.com . code of conduct because it is harassing, offensive or spammy. To create a new Excel document, construct a new WorkBook object with a valid file type. IronXL allows Christian to import and manipulate data from different sources to automate repetitive tasks and validate input data from 3rd party sources. With you every step of your journey. Resolving this error: If your application is Desktop based, compile your EXE with x86 CPU (Menu Tools, Options, select Projects And Solutions, check the show advanced build configurations. Search for the IronXL.Excel package and click on the Install button to add it to the project. easy to query and parse Open XML files by using strongly-typed classes. Together, with Bing Chat and first- and third-party plugins, you can focus on bringing your ideas to life, completing complex projects and collaborating instead of spending energy finding, launching and working across multiple applications. The SDK DOM is designed to make it The team and I are pumped to be back at Build with the developer community this year. If you need any further assistance, please feel free to post a comment. approach, you can employ an OpenXMLReader to read the XML in the file We have added native support for additional archive formats, including tar, 7-zip, rar, gz and many others using the libarchive open-source project. IronXL is a .Net Library development brought to you by Iron Software. b. Each WorkSheet object manages an index of Cell objects corresponding to every cell value in an Excel worksheet. The content in the IronXL works on .Net Core 2, Framework 4.5, Azure, Mono and, Mobile and Xamarin. Once unpublished, all posts by mhamzap10 will become hidden and only accessible to themselves. I need to read data like Row1col1 , Row1Col2 , Row1Col3 and Row1Col4. in this topic. about the basic structure of a SpreadsheetML document, see Structure of a SpreadsheetML document (Open XML SDK). exclude. I've just started building everything out and ran some tests. Python loads CSV files 100 This tutorial explains how to read an Excel file in C#, as well as perform everyday tasks like data validation, database conversion, Web API intergrations, and formula modification. LLVM v12.0 and onwards for cross compile and native compile options for Arm. We can read excel files no matter whether the file format is xls or xlsx. from row in book.Wor But Iron Software products are paid, we can read excel in C# using Epplus or MS Interop or OLEDB for free. With Olive & ONNX Runtime you can target Qualcomm AI Engine Direct SDK to run AI models on the 8cx Gen 3 compute platform NPU. Make sure the following components are selected: Universal Windows Platform It contains properties and methods that enable users to access and modify the cell's value directly. You must use the following using directives This is the recommended approach for reading very large files. To open an Excel File using C#, we use WorkBook.Load method, specifying the path of the Excel fil. Templates let you quickly answer FAQs or store snippets for re-use. Currently it is taking around 20 minutes to read 3508 records that is too long. The following code example contains two methods that You cannot perform any mathematical operation or working on graphs using OLEDB, but it is really a good way to insert/update data in EXCEL where no Excel application is installed. DEV Community 2016 - 2023. EntityFramework allows you to create a model object that can export data to the database. On IIS, change the "Enable 32-bit Applications" setting to True, in the Advanced Settings for the Application Pool. Below is a summary of the overal workflow for reading Excel files using IronXL: The code examples used in the next sections of this tutorial (along with the sample project code) will work on three sample Excel spreadsheets (see below for a visual): The first thing we need to do is install the IronXL.Excel library, adding Excel functionality to the .NET framework. ", Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\temp\test.xls;", Extended Properties='Excel 8.0;HDR=Yes;'". It is also possible to call GetRange on a WorkSheet. Another way of using IronXL is to download it directly from this link. You can also read Excel file in C# using MS Office Interop easily. this example, the parameter is false "A1", as shown previously) or a span of cells from left to right top to bottom (e.g. I've just started building everything out and ran some tests. But this way it can read column wise data and i want to read the data like first row all the columns then 2nd row and its all the columns one by one, have a look on this please http://stackoverflow.com/questions/17577184/importing-excel-into-a-datatable-quickly. You need a solution to read and extract relevant data from Here my only challenge is not only to read the excel data and put it into data table or data set but also after reading the column values i have to access oracle data base and do stuff. => Finally, click on "Create Project", and a project will be created and opened for you as shown below: Our next task is to Install the Nuget Package for IronXL. We are adding tab tear-out to Windows Terminal so that you can easily organize your different shells into windows according to your needs. WebWe would like to show you a description here but the site wont allow us. Reading and creating Excel files in C# and VB.NET is easy using the IronXL software library. NPUs (Neural Processing Units) are purpose-built accelerators to run AI models efficiently. Once unpublished, this post will become invisible to the public and only accessible to Mehr Muhammad Hamza. Over the last year, Windows has continued to see incredible growth fueled by Windows 11 adoption. In the previous example, we looked at the example of reading the data from an Xslx file. Step 1: Create a new Console applicaiton in your Visual Studio, by navigating to File->New->Project-> Select "Windows Classic dekstop" from left-pane & "Console Hello. Good and easy example using Ironsoft Made with love and Ruby on Rails. We are committed to not only providing you with the best tools to build great apps, but we are also enhancing the Microsoft Store, an open platform on Windows that provides the reach and growth that you seek. The first workbook I tested is 24 columns and 14000 rows. From the moment you open your device, youll have the ultimate productivity tools at your fingertips, empowering you to do your best work. Importing Excel data has become such a common task to my everyday duties, that I've streamlined the process and documented the method on my blog: best The IronXL team are available to help, during POC->development->testing>deployment. If the count is known, use a For loop. To create a new project, open Visual Studio, click on "Create New Project" => Select Template; I am using the Windows Form App, you can use any of your choosing. Use the WorkBook.GetWorkSheet method to retrieve a reference to a specific Excel worksheet. Upload only xlx or xlsx file type. Intel previewedtheir newMeteor Lake product, an all-new chipletSoC architecture that will feature Intels first integrated AI engine which will scale across the Windows ecosystem starting later this year and will also make available developer tools, including ONNX Runtime support enabled through OpenVino-EP and DirectML-EP. Reddit, Inc. 2023. The source code for this project is available in C# and VB.NET on GitHub. Note: With the help of sheet name, you can refer to Excel data, you need to use '$' with sheet name, e.g. I am writing a program that will read in Excel data from multiple files and eventually write all data to a single workbook. After you create this instance, you can use it to obtain access to the For our Windows Insiders, youll be able to start accessing a set of these new features later this week in an Insider Preview Build. EPPlus 5 requires a license for commercial use and their prices rise sharply for more than a few developers. Dev Home makes it easy to connect to GitHub and set up your machine to code for the repos you care about, easily installing the tools and packages you need. WiX installer v4.0 is available to create native installers for Arm. Posted 6-Jul-12 22:11pm Z.S.H Add a Dev Home is in preview starting today, you can install Dev Home from the Microsoft Store today. Web2. Very useful and awesome post. The second parameter takes a value of true or false and If mhamzap10 is not suspended, they can still re-publish their posts from their dashboard. email is in use. To open and work with an Excel document, you As explained previously, an IronXL WorkBook contains a collection of one or more WorkSheets. And you can use ONNX Runtime across platforms like Windows, iOS, Android and Linux, so your Windows AI investment can extend to all your app platforms. The following call makes a REST call with RestClient.Net. Invoking Windows Copilot is familiar and easy the button is front and center on your taskbar simple to find and use. Introducing Dev Home: Your new productivity companion, With a renewed focus on your productivity, we are announcing a new home for developers on Windows Dev Home. Each one represents a single Excel worksheet in the Excel document. xlsx file is the extension for a Microsoft Excel file. every spreadsheet. This gives you more control over costs and user experience, as Azure EP gives you the flexibility to choose between using the larger model in the cloud or the smaller local model at runtime. represents whether or not you want the file to be opened for editing. Any server admins will tell you that obsolete and unmaintained software is a massive security risk. The WorkBook class represents an Excel sheet. The following code sample d. Code to Read XLs and XLSX File The first statement will load the excel workbook "Weather.xlsx" for us. Developers can leverage these GPUs today to run cutting-edge transformer models like Dolly 2.0, Stable Diffusion and NVIDIAs NeMo that are pre-optimized for Windows. Reducing toil and unlocking the fun and joy of development on Windows with new features and improvements. Similarly then read Row1Col2 and fetch its Id from oracle table and so on till Row1Col4. Read from excel, modify and write back ///