Member Avatar
Hi i got a sheet in a work book that i am working on now with form control (dropdown). The code i made changes the color for the text in the entire row, or highlights it, works fine. But i would like to add code to change the cell value …
by Erik.Den.Eneste in Microsoft Windows ()
Member Avatar
How to php export to excel
by csshacker in Web Development ()
Member Avatar
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. …
by zelrick -1 in Software Development ()
Member Avatar
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 …
by ggeoff 4 in Microsoft Windows ()
Member Avatar
Hey Everybody. I have been asked to create a spreadsheet that will create a list of matches, for example we have the following array: ... OK, fair enough, basic table so far. What I want to do is have three columns, that will return the results that match the criteria …
by squeak24 in Microsoft Windows ()
Member Avatar
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 …
by rela in Microsoft Windows ()
Member Avatar
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 ... method to determine what worksheets are available within an Excel workbook allowing the end user the ability to select a specific worksheet in order …
by djjeavons 113 in Software Development ()
Member Avatar
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|| ... |test3|test4 file2.txt|alok| ... |test2|test3|test4 file1.txt|Rest| ... |rang|banh|test file2.txt|Rest||rang|banh|test ... | ... | ... | ... …
by Alok_3 in Software Development ()
Member Avatar
Hi all, Now I have no programing experience, I know very little about this, so please bear in mind. I am trying to turn a particular excel spreadsheet I have made (the user inputs information and it creates a final answer(result)) and I want to be able to turn this …
by webinvest in Microsoft Windows ()
Member Avatar
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: ... Unfortunately I have no idea how to get this information from the spreadsheet. I did find a link here …
by doncwilson_1 16 in Software Development ()
Member Avatar
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: …
by nugab in Software Development ()
Member Avatar
I am using visual studio 2008 (vb.net). I have a long list of file names in column A on an excel sheet. These files are located in a directory on my network drive. I have to copy these files over to another folder. I know how to copy files in …
by daveofgv in Software Development ()
Member Avatar
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 …
by regsamp in Programming ()
Member Avatar
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 …
by Programmer592 in Software Development ()
Member Avatar
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 …
by ehpratah 48 in Web Development ()
Member Avatar
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: ... Column E and Column G will be the referal; E1, G2, E4 must be highlighted since Column E and Column …
by zelrick -1 in Software Development ()
Member Avatar
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.
by bLuEmEzzy in Web Development ()
Member Avatar
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, And my PHP code as like, I used PHP function fgetcsv() My Excel file …
by rjony321 in Web Development ()
Member Avatar
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 …
by zelrick -1 in Software Development ()
Member Avatar
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 …
by SeekAnswers in Web Development ()
Member Avatar
How to unprotect excel sheet without knowing the password.
by adobe71 in Microsoft Windows ()
Member Avatar
After reading this excellent ... 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 Forms version: …
by ddanbe 2,372 in Software Development ()
Member Avatar
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.
by AntonyRayan 15 in Web Development ()
Member Avatar
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: ... Things to be done: …
by zelrick -1 in Software Development ()
Member Avatar
Hi - I have a corrupted Excel file which I can't repair. I wonder would any of you be able to repair it? It's Excel 2010 . Thanks.
by de_boer in Microsoft Windows ()
Member Avatar
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 …
by Sneaky Pete in Software Development ()
Member Avatar
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 …
by Monster99d in Software Development ()
Member Avatar
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 …
by ThomasBens in Microsoft Windows ()
Member Avatar
Cell C4 has the expression ... 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!
by Stagnant in Microsoft Windows ()
Member Avatar
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! ... …
by sonlamhpu in Software Development ()