629 Topics
 | |
 | 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 … |
| | Just wondering if anyone knows how to not save a document after creation when using Microsoft.Office.Interop.Word. Basically i am using mail merge to print off a report from c#, the document get made, values are passed to it no problem and i can then print it without any issues, however, … |
 | 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 …  |
 | Dear fellows , The problem is ,one of my client wants to setup a credit card system in his company. He want to provide credit cards to his clients to let them swap in the slot machines when they need money and all the slot machines need to connect with … |
| | 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 …  |
 | Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As …  |
| | hi all i am reading excel file from c# into dataset everything working fine but the problem is it takes first row of excel as header's of column and i have "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" in first row of excel ant … |
| | hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet …  |
The End.