Solved
April 30, 2012
How to find the row number of a specific value in Excel using vbscript
I have an open Excel file and using VB Script, I need to search only column "A" in the Excel sheet until it matches…
thumb_up 15
trending_up 8
excel
167 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
April 27, 2012
VSTO Excel Add-In with Visual Studio Express
I want to create an add-in (a ribbon precisely) for MS Excel by using Visual Studio C# 2010 Express. I have searched and read…
thumb_up 8
trending_up 4
Solved
April 19, 2012
Can’t close Excel completely using win32com on Python
This is my code, and I found many answers for VBA, .NET framework and is pretty strange. When I execute this, Excel closes. from…
thumb_up 3
trending_up 12
Solved
April 9, 2012
How to Open Two Excel Files in Multiple Monitors in Windows 7 pro excel 2010?
I want to open two (or more) excel windows on different screen (extended displays), But was not able to. I tried few solutions found…
thumb_up 5
trending_up 5
Solved
April 9, 2012
Parse Cell Location String into Row & Column
i have string col= "AB21" which is an excel cell location. I would like to parse it as string column = "AB" & int…
thumb_up 6
trending_up 5
Solved
April 7, 2012
Connect to remote sql database using excel
I'm using SQL Server 2008 R2 and Microsoft Excel. I have the server set up to be logged in via Windows user or database…
thumb_up 9
trending_up 2
Solved
April 5, 2012
How to programmatically create a “true” Excel file
Possible Duplicate: Generating an Excel file in ASP.NET Here's my question: How do you programmatically create a "true" Excel file? Note: I don't mean…
thumb_up 10
trending_up 6
Solved
April 2, 2012
How can I create multistyled cell with EPPlus library for Excel
I use EPPlus for Excel file generation. I mean I need to convert HTML text (bold, italic, font color,name,size parameters) to Excel Cell. I…
thumb_up 13
trending_up 12
Solved
March 8, 2012
Java to Excel 2010
First of all, hello to everybody! I have a piece of code which is creating an Excel file by using an open source library…
thumb_up 3
trending_up 7
Solved
March 5, 2012
Converting html to excel?
I know that excel is capable of opening html files directly. But the content of the file will still be html. Is there any…
thumb_up 11
trending_up 11