4,334 Topics
 | |
| | Hello! I've been debugging this VBA program that computes the root of an equation using Newton Raphson method and with the use of the UserForm. The user will type the equation, the initial guess and the number of iterations. I was able to search on automatically differentiating the equation unlike … |
| | We recently enabled folder redirection for a few staff members. After their PST file is migrated to the network share, Outlook can't read it. When we run the Outlook Inbox Repair Tool. We get this error: This data file appears to have been created using a newer version of Microsoft … |
| | Hi all. Can anybody help me? Yesterday I work with my access file with necessary data for my work and today I can’t open it. The version of Microsoft Office is 2003. Windows 7. Thank you! |
| | Hi, I hope you can help me out of this because i really dont understand how to fix this code anymore, i tried and tried and it don't work. When i debug this code in Microsoft Visual Express 2010, it says the following erros are: 1>------ Build started: Project: Adreesbook2, … |
 | 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 … |
 | |
| | Daniweb helped me straighten out my last computer with Malware bytes and Spyware when I was I was having trouble. When that computers had a problem with all its all its usb I had to switch computers quickly. Bought a secondToshiba since my wife liked them. This one had Windows … |
 | 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 all, my boss want me to send an calendar invitation event to Microsoft Outlook i have tried many time already and it still give me the result "This is no a valid internet calendar file" and here my code: [CODE] $vcal = "BEGIN:VCALENDAR"; $vcal .= "VERSION:2.0"; $vcal .= "PRODID:-//CompanyName//ProductName//EN"; … |
 | 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 …  |
| | i do an export to excel in asp.net and one of the columns does hold quite a bit of data (4k) [directly below]. as you can see below it's tabbed and has multiple newlines. using string builder does keep the data together in one cell, however the formatting is gone … |
| | 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 … |
| | How can I view locally(meaning my website is not yet publish on the internet), a certain file with extensions of .docx, .pptx, .ppt and .doc? Is there any libraries which i can call on my website like jquery? Please help.. thank you |
| | Does php copy() function can convert a certain file format, let say for example file.pptx convert to file.odp, is it possible?  |
 | 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 … |
| | Hello, I hope this is the right forum to ask this question. My requirement is as mentioned below: -> I need to create an appointment on my Default calendar and the same on other calendars that are shared with me by using Exchange Services (EWS). -> By shared, i mean … |
| | 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" … |
| | Hello I've found a working script for what I want to do: https://www.daniweb.com/programming/software-development/threads/384778/copy-files-from-a-list-in-excel Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'get the last saved settings btnCopy.Enabled = False txtExcel.Text = My.Settings.ExcelFile txtSrce.Text = My.Settings.SourceFolder txtDest.Text = My.Settings.DestinationFolder SetCopyButtonText() … |
| | 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 … |
| | 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 … |
The End.