4,334 Topics
 | |
| | Hi, I need to create an html page to export some information. Currently, by using java, i've exported information to excel. But now, I need to export the information in HTML page using java.Is there any APIs I can use? Thanks.  |
| | Hi there, I was trying to edit a excel document and save under different name and my coding for this is as follows. [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Open Dim MyExcel As New Excel.Application MyExcel.Workbooks.Open("C:\Test\WalkAir.xlsx") 'Extract MyExcel.Sheets("sheet1").Activate() MyExcel.Range("A99").Activate() MyExcel.ActiveCell.Value = TextBox1.Text MyExcel.SaveAs("C:\Test\alkAir.xlsx") MyExcel.Workbooks.Close() …  |
| | Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks |
| | [CODE]Imports System.Data.SqlClient Imports System.Data.OleDb.OleDbConnection Imports System.Data.OleDb.OleDbCommand Imports System.Data Partial Class Main Inherits System.Web.UI.Page Public strSQL As String Public strConn As String = ConfigurationSettings.AppSettings("strConn") Dim objConn As SqlConnection Dim objAdap As SqlDataAdapter Dim objCmd As SqlCommand Dim objReader As SqlDataReader Private Sub cbfGenerateTable() Try objConn = New SqlConnection(strConn) strSQL = "SELECT …  |
| | Hi, I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. how can I create a sample template using vb.net code? Thanks |
| | Hi, I just have this program that needs to create a downloadable template for the excel file that will be used later in my program, now I have this templates in my server and I think that i'll just import this file first and then put it in the data … |
| | Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to … |
| | Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if … |
| | Hi, thanks in advance to whoever can help me out here. I guess the issues with my computer are currently. 1. ping.exe using up a large chunk of the CPU, very erratic but sometimes going near 100% 2. When I open Firefox or Internet Explorer, another tab or window automatically …  |
| | please find attached screen prints on how my data looks on XL sheet (as-is). With the help of Macros, I need to cut every 4 columns and need to paste it in a different XL TAB. I have attached another Attachment which gives how my data should look once Macro …  |
| | Hello, and Thank You for taking the time to read this! A couple of days ago my laptop (running Vista Service Pack 1) started to play up, mainly the internet was redirecting me to ebay or some tacky advertising. So I tried to use AVG and found it dissapeared, then … Information Security advertising amazon-web-services apple apple-hardware audio client-server dns flash ide microsoft-access microsoft-office microsoft-windows office-suite pci-card pdf printer storage tablet tcp-udp video-card virus-malware visual-basic visual-studio web-browser windows-virus windows-vista |
| | Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … |
| | My problems first started on my son's laptop. Backed up his game saves and such to our other pc via external drive enclosure. Now the desktop pc is infected with something. And just today while updating database/scanning with MBAM on that one, I was on MY laptop and recieved a …  |
 | Hello people. I want to suggest you some must-have programs. 1. Power ISO. It is the best program for using "images". It is easy to use and powerful program. You can easily mount, make dvds from .iso, .nrg etc. [url]http://www.poweriso.com/[/url] 2. I want to suggest you Opera for browser. It …  |
 | I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest … |
| | I have this question. I have already imported all the excel data in the datatable, but now I want them stored in a 2 dimensional array, meaning I want to have this kind of thing in the array, something like array[x][y], where x is the row and y is the …  |
 | How to deactivate updating of microsoft office 2010 |
| | I appearts that I have the Google Redirect malware somewhere. About 2/3 of the time,when I click on a Google result, I get redirected. This behavior happens only in MSIE; it does not happen in Chrome. I have run Super Antispyware, MS Security Essentials, and MBAM multiple times. SASW finds … |
| | Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the … |
| | ok i just got this laptop from my friend and apparently it seems to have contracted malware, particularly ping.exe? i ran a GMER scan, but i could not save a log file. Malwarebytes' Anti-Malware 1.51.2.1300 [url]www.malwarebytes.org[/url] Database version: 911122703 Windows 6.1.7601 Service Pack 1 Internet Explorer 9.0.8112.16421 12/27/2011 2:31:27 PM … |
| | Hey there. I have a program that uses access, and everytime i go to install it for some one i have to keep my fingures crossed and hope they have office installed on their pc. Is there a way to run my program without buying microsoft office? (using access database) … |
 | This is my code, but its taking time to save record in excel. In SQL Server table have 11201 rows and 80 columns. please suggest private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; app.Visible = true; worksheet = …  |
| | Hi, I am having problem with my coding below when I would like to export the data from GridView to Excel Spreadsheet. Appreciate if you could share your valuable comment. Thanks [B]Error Message =[/B] Class 'System.Web.UI.WebControls.GridView' cannot be indexed becasue it has no default property. [B]Error Line[/B] = xlWorkSheet.Cells(i + … |
| | I have followed the sites directions and here are my logs: • MalwareBytes’ Anti-Malware log Malwarebytes' Anti-Malware 1.51.2.1300 [url]www.malwarebytes.org[/url] Database version: 911122701 Windows 5.1.2600 Service Pack 3 Internet Explorer 7.0.5730.13 12/27/2011 11:06:42 AM mbam-log-2011-12-27 (11-06-42).txt Scan type: Full scan (C:\|) Objects scanned: 243664 Time elapsed: 37 minute(s), 49 second(s) Memory … |
| | I downloaded a program and installed it using a p2p program and now my internet wont work. I scanned with symantec but nothing came up. I ran a system scan with HijackThis v2.0.4 and this is what came up... Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 10:34:56 AM, … |
| | Hello everyone, First of all I would like to thank everyone for all their efforts in helping us newbies in solving our problems when it comes to coding. It has been a while since I have seeked some help from this forum or any other for that matter. I stopped … |
| | So I was searching for that awesome pic of the anteater standing up saying 'f@ck you, I'm an anteater', for my wife because it is hilarious. Unfortunately, my AVG 'free' caught an issue, but it was too late. I noticed ping.exe in the task manager. Really appreciate you folks taking … Information Security apple audio client-server data-protection database-design dns flash ide microsoft-access microsoft-office microsoft-windows monitoring-software office-suite os-x pdf peer-to-peer printer sharepoint social-media storage tcp-udp video-card virus-malware web-browser web-design windows-virus |
| | Ok, I have a Windows 7 Ultimate 64 Bits system, so in the beginning, I couldn't use the Microsoft® Windows® Malicious Software Removal Tool because it says that it is not compatible with my system. Then I used the ATF-Cleaner and it was OK. Then I downloaded GMER and the … |
| | Still finding my way around here.. Its a bit different once you join. I always come here looking for pc solutions or legit software program recommendations. I am female and married. Have 3 children. My hobbies are Painting Old masters Impressionist Paintings and Computer Graphics. Creating stuff.. a bit of …  |
 | Hi I have two desktops one has Office 2003 and the other my "graphics and video PC" has Adobe Creative Suite 3 Design Premium. Both use XP Pro. I can't use Adobe Acrobat as MS Word is installed on my other PC. There are a few other issues, that lead … |
| | [CODE]using Excel = Microsoft.Office.Interop.Excel; namespace program { private void cmdOpen_Click(object sender, System.EventArgs e) { FileSystem.FileOpen(1, inputfile, OpenMode.Input, (OpenAccess)(-1), (OpenShare)(-1), -1); // 1 : excel file Excel.Application MyXl; MyXl = new Excel.ApplicationClass(); MyXl.Visible = true; Excel.Workbook xlWorkbook = MyXl.Workbooks.Open(inputfile, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, … |
| | // ws is an object variable of worksheet // systype is a string variable Range r = (Range)ws.Cells[2, 2]; systype = r.Value2.ToString(); how can I combine these two lines into one single line ? Please help .... |
| | So, yes, what I am looking for is already posted, but I don't understand the logs and there is no answer, as well it seems like a customized answer for every user, and I don't think I can post my logs into someone else's to avoid confusion. A couple of … |
| | Shortly after Thanksgiving, I was having issues with the Ping.exe running my CPU usage up to 100% and freezing my computer. I ran my Avira Antivirus and it said it had found a Trojan, and quarantined it. However, after this, I was still having issues with the Ping.exe issue. I … |
| | Hi. I am having some trouble with my computer. Here is a quick review of issues...About a month ago my McAfee AV kept getting turned off. I could not figure out what was wrong. Nothing was found on any scans. I removed McAfee and got AVG free edition. It stopped … |
| | Ping.exe is grabbing so much CPU time that I max out at 100% CPU. When I stop the process tree, ping.exe keeps coming back. Your help will be most appreciated. ATF Cleaner didn't run - got "Not Responding" in Task Manager. Got the following GMER pop-up: "Warning GMER has found … |
| | [B]Read a CSV file into a DataGridView[/B] [CODE]'12/4/2011 'Code to read CSV file with headers using 'ACE.OLEDB.12.0 Connection 'The following is a Sampling of <EXTENSION.csv> 'The CSV file contains all the Extension on my Desktop Computer 'The full file has 923 Rows with Headers: 'EXTENSION,DESCRIPTION,EXECUTABLE_PATH '.mde,Microsoft Office Access MDE Database,C:\Program … |
| | I have a server that I just did a clean install on with Server 2008 Enterprise x-64. I have been having issues installing certain applications and unfortunately, I am at a loss as to why. I installed SQL Server 2008 Std, which went fine, but SQL Server management studio will … |
| | hey guys, everytime i shutdown my notebook i get an error of rundll32.exe. here is a log of my hijackthis. Logfile of Trend Micro HijackThis v2.0.4 Scan saved at 22:43:49, on 7-12-2011 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP3 (6.00.2900.5512) Boot mode: Normal Running processes: C:\WINDOWS\System32\smss.exe … |
| | Hi All, Finally getting somewhere with this project and can see the light at the end of a very long tunnel.. I have one more hurdle to overcome so any help in pointing me in the right direction would be greatly appreciated. I have a bound datagrid which I fill … |
 | Hello Everyone, I want to transfer data in export from my php reports. it works also. but the problem is when i open that .xls file in notepad i can view all my data. i don't want this.my data will be unsecure.can anybody tell me solution?? code is as below: …  |
| | Hi members, I am not good enough to interpret the logfile below. Could someone please have a look at this and make suggestions as to what may need fixing. I got a virus a couple of weeks ago and now some files will not open and I have lost the … |
 | HI i am trying to convert a doc file to a pdf file. please see my conversion code below [CODE] private string m_SourceFilePath; private string m_DestFilePath; public bool DoConversion() { bool returnValue; Word.WdExportFormat exportFormat = Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF; object paramMissing = Type.Missing; Word.ApplicationClass wordApplication = new Word.ApplicationClass(); Word.Document wordDocument = null; try … |
| | Ok a couple days ago I got hit bad with some Malware. I've been trying to get rid of it since then. I think I got most of it but my computer has been running realy slow and I noticed that I was getting the hourglass symbol popping up every … |
| | Greeting fellow Humans, I'm trying to "[I]comb merge[/I]" (if any thing as such) bunch of Excel files. There are 2 type of Excel workbook: A & B Both has a column called : [I]Location ID[/I] [U]These are the step I think the prog should do [/U]: Promp user to select … |
| | Hi everybody. I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this: |_ col 1__|___col 2___|___col n____| row 1......|....2row 1 row 2......|....2row 2 row 3......|... 2row n What … |
 | =rand(100,1000) type this on your ms office if you have then a magic will happen...  |
| | Hi, I needed to create in-cell dropdownlist in excel using VB.NET, So i used the code, With xlWorksheet.Range("H2", "H101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:="Maintenance Planning") End With It works fine with Excel 2003, but it does not works on Excel 2007. It shows below message, Excel was able to open the … |
| | I am currently having a very similar problem. I followed the directions in the sticky. Here are my log files from GMER and DDS I will follow up with Malwarebytes log when it finishes. My connection to my network has been acting up since this started as well it wont … |
| | hello, i've had this problem for over a week now, and i tried numerous fixes (virus scan, delete temp folder, reset router and modem...) but i can't seem to fix it, help me! so about a week ago, for some reason my internet stopped working, it's quite weird. for every … |
The End.