[excel] Forum Topics

hi, I am working on an asp application using c# and i can import excel file to sql table i have two columns in excel and as well as in sql of same name "id" and "status" when i import data both columns are imported to sql table in the …

Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' …

Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are …

I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula: =LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4))) This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. …

Hi Guys... looking for a quick answer on excel Formula.. Anyone know why my text "Please Chase" is not showing up? =IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase")

Good day folks, lines = IO.File.ReadAllLines(txt_Source.Text) I have here a line of code which reads a text file and save it to an array, It works well. But I wanna ask if there is anything like this code that can be use to read a excel file? Something like this …

Hi ! I have a column of 'City', now I want to compare the value of each cell of 'City' against the column 'City_Check'; the cell where the value matches, pick the value of 'City_ID' column & replace the city name with that ID in the 'City column'. * The …

I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next …

does anyone know how to make syntax of max if in vb excel 2007? (not formula)

I am trying to set the value of cells in an Office 2010 worksheet using this code in Visual Studio 2012: for (int i = 1; i < 5; i++) { xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(i); int columnCounter = 1; foreach (string s in columnNames) { range = ((Excel.Range)xlWorkSheet.Cells[1, columnCounter]); range.Value = …

I want to put the total on the last row of the sheet regardless the number of the records. If 10 rows are populated, i want to put total on 11th row. If 12 rows are populated, i want to put total on 13th row. If I based the adjustment …

I am working on a project in which i do some calculations for products and produce some end results then browse an excel file containing reference value for the products, but now i require that if a particular product is not found, that product should be automatically added to the …

Does anyone how to hide excel macro worksheet each time excel 2007 starts up? using vba syntax thx

I am opening a tab-delimited file in Excel 2010; the delimited file displays correctly in Excel but when I do a save as, to save it as a native Excel 2010 format, the resulting saved file is empty. The resulting saved file generates no errors when debugging and saves with …

Hello everyone my name is andy... is anyone know how to make a simple data entry worksheet in excel 2007? i noticed that excel 2007 have a form control inside the developer tab i can add input text box and command button in sheet1 but i dont know what syntax …

I am trying to add an excel file(.xlsx) as a database to my vb.net 2010 project. But it does not recognize excel as a database type, it can only connect with access or sql. Any idea how excel can be connected to the project? Or should I just use file …

Good day, I am having trouble with the excel file that i was uploaded.. after i uploaded the excel file i want to validate each header and each datatype of it. just to make sure that my dbase has integrity.let say i have 10 columns. Is there a way on …

Hello friends, I'm tring to make excel file using vb but i don't know how to do it. There anyone know how to do this. Thank you. Eko

I have MS EXCEL 2k3 problem: On my previous post I have the NOT the INTERSECTION of 2 sets of data using VLOOKUP() where is the equivalent function of INTERSECTION in Discrete Mathematics. Right now I was looking for forums if Excel has the ability to combine 2 sets of …

Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has a b c d e and f the data of Line B has b and d only if I use …

what I am trying to do is use this php script to load the data being submitted in the html form into my database and then populate the database into an excel (csv) file and then e-mail it to my address. Everything works great it populates into the database and …

I dont know where to post it, but this is the reliable help from geeks I've known for several years Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has …

Is there a way to remove blank worksheets from an excel report that is generated in SSRS? I've done some research and i could find solutions such as removing blank rows and even entire sheets but only via marcor's in excel, which won't work in my case as the report …

I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions. In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which …

I want to delete the contents from cell if the content of that cell are similar to the content of the previous cell of last column. i.e If the 10th cell of column 'A' & 10th cell of column 'B' have the identical content then I need to clear that …

Hi Guys.. Can any experts in Excel/C# Help me with this one? I think I'm nearly there. Currently I have a DGV on a windows form which pulls data from a Datasource. I want to export the findings to and Excel report template. I've managed to export the data into …

Hi, it's me again.. I have this codes wherein I can export the data from the databse to Excel.. I get a **Notice: Undefined variable: aData** on one of the php files.. well two of them actually.. The weird thing is... The other page which I have modified - i …

Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents …

Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with …

Hello guys, I would appreciate if you could help my on the below issue. When i used an Excel object in my code, when closing this, the excel.xls applicataion remains opened at the task manager. i am copying below the test code for your reference, which i am using in …