534 Topics
|
|
|
|
|
Hello DaniWeb Users/Programmers, I don't know if I post this on the right thread but I already post in Linux and Unix Thread but the cause I try ask in here is because it is programming related. I am a window user but trying to use linux for some purpose. … 
|
|
Hi I thought this was easy. I want to copy a spreadsheet in a workbook to a new spreadsheet in the same workbook preserving links. So as the source worksheet received new entries the copied spreadsheet would be updated. My reason being that I would introduce some variation in the … 
|
|
|
Hey Everybody. I have been asked to create a spreadsheet that will create a list of matches, for example in Table 1. (Please see the tables attached). OK, fair enough, basic table so far. What I want to do is have three columns, that will return the results that match …
|
|
|
Hi, I could import some numbers from notepad to excel 2010, and after right click the cells were converted to General from scientific format. However, when I drag the notepad file to Excel 2013 they cannot be converted to General format. I tried different ways to convert them from text …
|
|
This code snippet demonstrates how to use ADO.NET to read the contents of a Microsoft Excel Worksheet. This snippet also demonstrates the use of the [GetSchema](https://msdn.microsoft.com/en-us/library/ms135981%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396) method to determine what worksheets are available within an Excel workbook allowing the end user the ability to select a specific worksheet in order …
|
|
|
Get difference of two text files in excel and highlighting the difference using python. eg. file1.txt alok|test1|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest|t1|rang|banh|test Must|t1|rang|banh|test file2.txt alok|test11|test2|test3|test4 alok1|test2|aewer|262771|262772 Rest||rang|banh|test In excel the difference should be shouwn as below: file1.txt|alok||`test2`|test3|test4 file2.txt|alok|`test11`|test2|test3|test4 file1.txt|Rest|`t1`|rang|banh|test file2.txt|Rest||rang|banh|test `file1.txt`|`Must`|`t1`|`rang`|`banh`|`test` Basically if a record is present but with some field with different …
|
|
Hi group, I'm modifying a VB.net app where I need to loop through an Excel spreadsheet for data out of two column. In essence the code will need to read: For i = 2 to end of file propNo = Cells(i, 2).Value crms = Cells(i, 8).Value If crms = "Y" …
|
|
|
Hi everyone, I'm new here. I don't know VBA and have been tasked with a VBA project for whatever reason. We have a recurring bug wherein a report we receive has semi-fake rows, causing all kinds of hell. The current logic I am attempting to execute should run as follows: … 
|
|
|
I have an Excel sheet that I am looking to combine two columns from one sheet into a new sheet. I am including the Excel file. The columns are the B and R from the Title_Frame_Register sheet. I am trying to output to a new sheet and it what I … 
|
|
Hey guys. So I'm currently building an app and I'm having a bit of trouble. So I have an Excel file and it reads it and opens it fine(I imported microsoft.office.interops.excel but what I want to know is how to loop through column A and pick out the rows that …
|
|
Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is working fine if im am only getting 1 specific record). but when i tried adding a loop to create a …
|
|
|
Hello C++ Programmers; I would like to know if fill color can be automatic fill up a whole row when in two column have a number 6; for example: A B C D E F G H I J 1 98 132 3 146 6 54 8 210 8 2817 … |
|
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 …
|
The End.