534 Topics
| |
Hey! Firstly, here's the code: for (Row row : sheetToSearch) { for (Cell cell : row) { if(cell.toString().equals("Oladimeji")){ System.out.println("Found Oladimeji!!"); break; } else { System.out.println("Oladimeji not found...."); } } } What this does is search through the an excel spreadsheet, looking for a name (which happens to be my surname!). … | |
Hi I have been experiencing high CPU usage for the past few days. Upon investigation I found out that the iphlpsvc was constantly running at 25% alongwith gpsvc, together putting the CPU usage to frequently 100%. I ran MBAM and AVAST scans I assume they couldnt find anything to fix … | |
I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column … | |
How can I take a copy of the text inside listbox to Excel Sheet or Word Page ? Thank you | |
Hi! Firstly, here's the code: if(new File("ATM.xls").exists()){ System.out.println("File exists"); } else{ File excel = new File("ATM.xls"); } What I'm trying to do is check whether or not a file exists and then create said file, if it does not exist. This all works fine, but somehow, I'm unable to use … | |
Hi All I use MS Access to import information from Excel, check for duplicates and post it to an Access data table. The amount of data is making this process extremely slow. I am attempting to move the data tables to MySQL and then running a Stored Procedure to do … | |
Hello Everyone, is it possible to create excel file without excel installed on machine in vb6 code? is there any code, dll, link is available? Thanks. | |
Not sure how to put my code in to excel. 1.#include <iostream> 2.using namespace std; 3. 4.int main() 5.{ 6. const int n = 20; 7. int Array[n] = { 3, 5, 2, 9, 6, 12, 16, 11, 18, 4, 14, 8, 1, 15, 17, 7, 19, 13, 20, 10 … | |
Good day guys I need help for adding 2 column in datagridview my project is : the import and the varibles are : Imports Excel = Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop.Excel Imports Microsoft.Office.Interop Imports System.Runtime.InteropServices Public Class Form2 Friend xlApp As New Excel.Application Friend xlWorkBook As Excel.Workbook Friend xlWorkSheet As Excel.Worksheet Friend … | |
Hi, how to plot a chart from imported excel in Datagridview? I tried the tutorial from [HERE](https://www.daniweb.com/software-development/csharp/code/492766/display-excel-data-in-a-datagridview), but I do not know how to plot the chart. Previously, I used MS.Access for my Datagridview, then I manage to choose the Datasource. But, for this case, I imported an excel and … | |
Hello !! I use vb.net with excel I have a buttom "get the name of the column from worksheet" with a combobox thi is the code of the button: Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click Dim Excols As New Dictionary(Of Integer, String) Form2.xlWorkSheet = … | |
This snippet demonstrates how you can add VBA code to an Excel file at run time. **Prerequisites** In this snippet I am using Microsoft Excel 2013 with the Microsoft Excel 15.0 object library. Before you can use this code, you will have to change a setting within Microsoft Excel to … | |
I'm printing some strings to the output console to visualise an array, so I'm looping though a string array and using `Debug.Write(array[x,y] + "\t")` etc... All was fine before I went to bed, and the output was fine, like this. "type-b flat three core 29/03/2015 23:34 6 £13.65 wire grade" … | |
Hi. In my application I'm using Excel to get some data into an array from a worksheet. Here is my method. public string[,] WorksheetToArray(string path, bool visible = false) { oExcel oXL = new oExcel(); // here new icon appears. if (oXL.Error > 0) { MessageBox.Show("An Error Occurred" + "\r" … | |
Here she is! Logfile of Trend Micro HijackThis v2.0.5 Scan saved at 6:52:26 PM, on 3/25/2015 Platform: Windows 7 SP1 (WinNT 6.00.3505) MSIE: Internet Explorer v11.0 (11.00.9600.17689) FIREFOX: 33.1.1 (x86 en-US) Boot mode: Normal Running processes: C:\Program Files (x86)\Malwarebytes' Anti-Malware\mbamgui.exe C:\Program Files (x86)\Extensis\Suitcase Fusion 5\FMCore.exe C:\Program Files (x86)\Intel\Bluetooth\BTPlayerCtrl.exe C:\Program Files … | |
Hi Dan, i am looking for something where i click on the button and the excel sheet opens. i have created buttons on the VB excel but i am looking for the coding about how should i link the excel sheet with the command button? please can you help? regards, … | |
I'm getting an excel range to an array. From my search it was clear I need to use object array. object[,] saRet; oRng = oSheet.UsedRange; saRet = (System.Object[,])oRng.get_Value(Type.Missing); This works fine, but what I really need is for that array to be string. So how might I cast object[,] to … | |
Hi, so I have a dataset which I am using to create a CSV. When I run the code in debug mode and use the datatable visualiser all the data is shown, however when it opens in excel the last two cells of the last row are missing. I can't … | |
Hello Sir I want the php code to import the excel data into mysql . pls hel me Thanks | |
Hi, I hope someone out there can help me. Envision this ... an accounts receivable / accounts payable super simple spreadsheet, to ultimately be maintained by someone who is not computer literate. It needs to be accessible from within the cloud (Google Spreadsheet, some other free SaaS product, etc) with … | |
Hi guys, I want to create a window application from VB, so that a user can enter the **OLD Power** value in table. Then **line chart** will be created in that windows application. My **Old Power** data already obtained and recorded in Excel. So, in that window application, 1) The … | |
Hi all, I would like to return an array of String variables from a C++ DLL to a VBA application. My understanding is that: [LIST=1] [*]To do so, the C++ function must return a SAFEARRAY of BSTR. [*]Although Excel uses BSTR containing wide characters (wchar_t), VBA itself uses BSTR with … | |
We have a shared network drive with excel spread sheets on them, the connect between the two buildings is via a microwave, and every now and then the spread sheets will lock up. Can anyone suggest a budget sensitive solution that could improve the connection, and/or help with the freezes? | |
Hi Evryone. I'm new to this group , this being my first post. I have a query which if sorted out could benefit allot. I have searched bt couldnt come to a solution. I just need a direction and a say that "[B] whatever i'm proposing to do is FEASIBLE"[/B] … | |
hy when i run this command to open excel and i get error (on 2007 excel it was fine) //Excel.ApplicationClass xlApp; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; SaveFileDialog oDialog = new SaveFileDialog(); xlApp = new Excel.ApplicationClass(); ** xlWorkBook = xlApp.Workbooks.Add(misValue);** xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = … | |
Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How … | |
Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a … | |
Hello Group! I am in need of converting a "text" file created by a UNIX based program (it is only semi-formatted) and put it into a more-formatted text (.txt) file. Put a different way, this needs to be converted such that it can be opened in Notepad and it be … | |
I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing … | |
Hello everyone! Is there a way in VBA to find a file name that has an unknown portion to it? Let me explain: Our computer system is UNIX based. It is creating a text file for us that uses the date, the hour, minutes and seconds that the file was … |
The End.