629 Topics
 | |
 | Hey, I am trying to create a form where in I can input 3 or more values on it, but I do not know where to start I am planning to create a datagrid like in PHP, Guys can you help me? Thank you. |
 | Dear, I need help, how to import my Excel file into Mysql Database. I can successfully upload excel file but its not correctly formated uploaded or imported. please check this image,  My HTML Form looks like, <form enctype="multipart/form-data" method="post" role="form"> <div class="form-group"> <label for="exampleInputFile">File Upload</label> <input type="file" name="file" … |
 | Hi everyone; I got no idea how to start this and if it is possible; I have a text file (.txt) that have lot of lines and I want it to transfer it in Excel (.xlsx / CSV) But not all will be transfer in excel, only a specific number … |
| | Hi, I'm a web developer for a small company, I had programmed using ASP about six years ago, thus my skills are very rusty at the moment...recently, my boss had asked me to export the database information from the ASP pages to an Microsoft Excel file, allowing the users to … |
| | How to unprotect excel sheet without knowing the password.  |
 | After reading this excellent [code snippet](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview) by djjeavons, and just trying to learn WPF, I decided: "Well, let's translate that to WPF!". It was a bit harder than I thought, but a great learning experience! Her's how my screen in action looks:  Things that changed compared to the … |
| | I have lot of values in mysql database. I want to display all that data in excel file. How to do? without plugin is it possible? or how to do? Without any plugin, is comfortable. I am new to this concept.  |
| | Hello VB.net Programmer; Good day Daniweb'ers; I have a problem to my Excel Data going to DGV; Only Selected items in excel will be put in the DGV; I don't have a database for this problem; So here it is; This example from excel file: 1 2 3 4 5 …  |
| | Hi - I have a corrupted Excel file which I can't repair. Cannot attach the file writes that "The file type you are attempting to upload is not allowed." When I open the file writes that "cannot open the file because the file format or the file extension is invalid. … |
| | Hi guys, To make Some things easier, I want to make a program that can do the following: 1. Import a .txt file to a specific .xls file. The .txt file contains several lines of data which is build like this: (aaaa,bbbb,cccc,etc.) sererated by comma. Imported in excel, I would …  |
| | Hi, I'm trying to learn VBA for a personal project I am working on for excel. Right now I have in cell A2 - "2 years 1 month" and in cell B2 "1 year 2 months." I am trying to get it so it prints in C2, "3 years 3 … |
| | What tools have people had the most success with for repairing corrupt Excel files? I have had 2 people come to me recently with corrupt Excel files (oolone was XLS and the other XLSX). I tried opening the files with versions of Excel and repair but nothing. I then tried … |
| | Cell C4 has the expression =565+660+709+1093 Is there a function/nest of functions that can output the number of values being added? BIG NOTE: I AM NOT ASKING FOR THE SUM OF THE EXPRESSION!  |
| | Dear brother Sorry for my bad english Please help me in this case I import with big data to Datagridview It's take long time, and i want to using progessbar for wait I try to do this But it's seem not good Please help me Thank you so much! `Inline … |
| | Hello VB.net Programmers, Please help about delimited. I've been looking to the forum and other sites about this but can't find any. Here is my problem. 1. I need to put the text file to excel but this text file don't have comma and tab. This are separated only with … |
| | Hello VB Masters, Firstly, apologize if my question is in the wrong place :) I would like to create a loop that will copy a data from rows in the first sheet to the columns in the second sheet. The data in the Sheet1 looks as follows: A B C …  |
 | Hi group, I'm attempting to create and write to an Excel spreadsheet with data from a text file. The code is meant to parse each line of the text and place the data into individual variables. I then need to place these variables into the appropriate cells on this newly … |
| | Hi I have data set where I find it easy to sort data by using pivot tables. BUT one essential cell is not a part of each sample ID. I have tried to make a macro to insert this data without luck. So in b column every time an empty … |
| | Am having a little problem with importing data from MS SQL to and Excel sheet. I followed previous answers on daniweb, but they couldn't help me out. Here my code. Private Sub btnExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExcel.Click Dim appXL As New Microsoft.Office.Interop.Excel.Application Dim shXL As … |
| | Hello Group, I'm attempting to create and write to an Excel file. I'm sure I've hit the first of many snags. Hopefully you can point me in the right direction. In this first attempt, I'm getting an error code: "Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))". The error is attached … |
| | Dear forum members, i a m trying to export the contents of datagrid to excel but i am facing errors.After searching i have seen that the problems occurs because one of my columns is of type TIME and taht is why i am getting the error : Object reference not … |
| | Good day! I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass …  |
| | We had a need to factory restore our PC. It is Windows 7 Home Preimum with SP1. We copied all data off ran the factory restore drive, reinstalled Office 2007, restored all data files and now when we open Excel files we cannot format them proerly. The page breaks will … |
| | Hello all, I am using Office.Interop.Excel.Application in which i have to save a file using saveas() but before saving it i have to disable the Excel's OverWrite prompt . I did tries Application.DisplayAlerts = false; But it's not working , How to do this??? Pl Help ? |
| | I am having an issue with a formula in excel and am not understanding what it is doing =COUNTIF(J28:L31,"w")+COUNTIF(J28:L31,"l") is supposed to give me a result of the number of cells with the value of either w or l in that range But instead of displaying a number, it is … |
| | I'm currently have and excel speadsheet that has 3 rows. What I would like to do is create a macro that reads the last populated row, usually will be column A1, and then created a new column listing the current date and time. So for example, I have ColA ColB … |
| | How to export the column data from excel to listbox without using database. plz help  |
 | My Mac address book syncs itself with my iPhone. Somehow (I think through Microsoft Entourage??) it silently added contacts to the address book for everyone I sent/received an email to/from. I now have thousands of contacts that have an email address only with no phone number, and I don't want … |
| | Group, In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me. foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*")) In advance, thanks … |
| | I am using following C++ code to enter a value of X which is used to print out variable CDF. This C++ code is expected to give very similar value we get from NORMDIST function in excel. However I get following error in debugger with out getting any output in … |
The End.