Tech-Today
To read an excel document, you need the excel interop. Most of the time people are confused on where is this library located.
VS2003
Add Reference->COM->Microsoft Excel 11 Object Library
VS2005
Add Reference->COM->Microsoft Office 11 Object Library
Or try both.
- The Program Can't Start Because Api-ms-win-crt-runtime-l1-1-0.dll Is Missing
This problem is often encountered when running Microsoft Office, Adobe Products or even Apache server. Base on this entry from stack overflow: http://stackoverflow.com/questions/33265663/api-ms-win-crt-runtime-l1-1-0-dll-is-missing-when-opening-microsoft-office-file...
- Google Map Api - An Example Implementation In C#. Converts An Array Of String Addresses Into Longtitude, Latitude Pair
Objective: -To create a web application that will use the google map api to produce longtitude, latitude locations. The application will read string address values from an excel document. So it's also an excel reader. What you need: 1.) Visual Studio...
- How To Create A Java Application That Can Read And Write To An Excel's (microsoft Office) And Calc's (open Office) Worksheet
Requirements: -JOpenDocument: http://www.jopendocument.org/downloads.html (calc worksheet api) -Excel POI: http://poi.apache.org/download.html (excel worksheet api) -JUnit: http://sourceforge.net/project/showfiles.php?group_id=15278&package_id=12472...
- Where Is The Excel Autofit Column Width In Microsoft Office 2007
For those of you who want to show the whole column width of a cell just like the previous office, here's how (it took me a while): 1.) Open your excel document 2.) Make sure Home tab is selected (top left) 3.) Select all the cells, or the column you...
- The Process Account Used To Run Asp.net Must Have Read Access To The Iis Metabase (e.g. Iis://servername/w3svc)
I encountered this problem when I install the IIS after the framework. You need to manually register the IIS. http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx Usually: C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i ...
Tech-Today
Missing Microsoft.Office.Interop.Excel.dll
To read an excel document, you need the excel interop. Most of the time people are confused on where is this library located.
VS2003
Add Reference->COM->Microsoft Excel 11 Object Library
VS2005
Add Reference->COM->Microsoft Office 11 Object Library
Or try both.
- The Program Can't Start Because Api-ms-win-crt-runtime-l1-1-0.dll Is Missing
This problem is often encountered when running Microsoft Office, Adobe Products or even Apache server. Base on this entry from stack overflow: http://stackoverflow.com/questions/33265663/api-ms-win-crt-runtime-l1-1-0-dll-is-missing-when-opening-microsoft-office-file...
- Google Map Api - An Example Implementation In C#. Converts An Array Of String Addresses Into Longtitude, Latitude Pair
Objective: -To create a web application that will use the google map api to produce longtitude, latitude locations. The application will read string address values from an excel document. So it's also an excel reader. What you need: 1.) Visual Studio...
- How To Create A Java Application That Can Read And Write To An Excel's (microsoft Office) And Calc's (open Office) Worksheet
Requirements: -JOpenDocument: http://www.jopendocument.org/downloads.html (calc worksheet api) -Excel POI: http://poi.apache.org/download.html (excel worksheet api) -JUnit: http://sourceforge.net/project/showfiles.php?group_id=15278&package_id=12472...
- Where Is The Excel Autofit Column Width In Microsoft Office 2007
For those of you who want to show the whole column width of a cell just like the previous office, here's how (it took me a while): 1.) Open your excel document 2.) Make sure Home tab is selected (top left) 3.) Select all the cells, or the column you...
- The Process Account Used To Run Asp.net Must Have Read Access To The Iis Metabase (e.g. Iis://servername/w3svc)
I encountered this problem when I install the IIS after the framework. You need to manually register the IIS. http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx Usually: C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i ...