I have several models that will need to be translated to other languages and I want to put all text strings on a separate tab so they are all together. I need a utility/tool to locate standalone and embedded text strings, move them to another tab, and replace the original text string with the cell reference to the new location. A bonus ...
Hi, I need some feedback on what is the best way to do what I want to do, allow me to situate. I have a huge database which receives new inputs constantly. Now I need to have an excel file which shows all the columns of inputs of the past day. So I thought the best way to do this is to use SSIS packages. I never really used SSIS that m...
I have the following code: Private Sub SortWorksheet(ByVal sheet As Worksheet) Dim sStartColumn Dim iTopRow Dim sEndColumn Dim iBottomRow Dim Rng As Range Dim sRange1 As String . . . and I am calling the function like so: SortWorksheet (DestSheet) I am getting a runtime error on the above line sa...
I have a GridView that I want to export to Excel. When I use the sample code I find online, it exports the content to Excel just fine, but for some reason it also clears out all grid lines outside of my exported table. For your average excel user this is easy enough to fix, but I need this solution to work for everyone. So then is ther...
Hi: I have a excel file with columns values Shaded/Active I need to get sub string before / Any idea? Thank you in advance ...
Hi, Please help me through a C# code that In VSTO excel whereever i selected a cell the respective column gets focussed. I need to get the Column value(which column) and row value(which row no) on excel worksheet wherever i focussed. Please help me to get the same through code. And also i would like to learn VSTO Excel using C#. Sugges...
Hi, I'm creating excel spreadsheets for reports using the XML method, where you export a valid Microsoft formatted XML, and then export it to Excel. So far everything works as it should, but I'm having some trouble with the colours. I've created one style such as: <Style ss:ID="s64" ss:Parent="s25"> <Font ss:FontName="Tahoma" x:...
I want to do quick calculations in Excel. I have a cell (A1) with 50:00:00. I do =A1+1 and get 74:00:00. So, I guess 1=24 hours=1 day. However, I try =A1+1:23:45 and get an error. Is there an easy way to add hours to hours in Excel? If not, do you have a better tool? Please don't say something like =A1+1/24+23/24/60+45/24/60/60. ...
I have this Java program that uses apache poi to load data from an excel file. Problem I'm facing is I can't seem to load data from the excel file that is constantly updating. I only get the initial data when I run my java program. ...
I want to use Access database with query for pivot table in Excel. How do I do that? ...
I have the following error for every cell: "the number in this cell is formatted as text or preceded by an apostrophe" To duplicate the error: I have to store this results that come from a Web services as strings array: Sample: (3 by 3 array) $402,568.03 26.2% 30,052 $107,719.59 7.0% 55,176 $81,370.35 5.3% 54,365 let values ...
Hello, I know that my question will be very similar to other ones already asked on SO but as I can't find a satisfying answer, I try my luck ! Does so know whether it's possible or not to generate charts in an Excel spreadsheet using the NPOI library. I have read that blog but it gives an example where there is already an existing te...
I need to export a gridview to excel, I put the return html code from the gridview to a HtmlTextWriter and put this into the response. The result file work fine in excel, excel can parse the html and the result is readable, work perfect on excel 2003 and 2007, but in some machines with Excel 2008 (MACOS) excel shows only the raw html co...
On one of our Java application screens, we want to display data loaded from an Excel file on a Excel-like spreadsheet component. The component has to be able to evaluate the formulas within the spreadsheet and also preserve the general cell formatting as in the loaded Excel file. We have to be able to programmatically change cell values...
Is there any method to preview Excel files on XP besides WebBrowser control? How does the WebBrowser itself preview them? ...
I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password from a database To meet the second requirement the prog...
I'm creating Excel files in a PHP project. Those files aren't just CSV data... They are multiple tabs spreadsheets with functions and formatting. So far I'm using the Spreadsheet_Excel_Writer class that is provided with Pear. Everything is fine but our users don't like 2 things: When they open those files generated by PHP, modify the...
Please Help. I want to copy just one Sheet ‘MainFinal’ among twelve other sheets(not all of the sheets in the original), to another .xls file using Excel VBA . The code I have attached below works , except it copies all worksheets and not JUST the one, and also when new file created it opens and source file is closed . Anyone have any ...
This is an excel sheet which has only a single column filled for each row. (explanation : all CITY categories fall under V21 , all handset categories fall under CityJ and so on ) V21 CITYR CITYJ HandsetS HandsetHW HandsetHA LOWER_AGE<=20 LO...
Hi, I'm creating set of user defined functions, but I only need to recall these function if and only a input parameter of a partcular function is change. Currently, even I delete/insert a row the function are being called, How can I stop this function recalling ? Thank You ...