534 Topics
| |
Hi Team, I was wondering if I am the only one who is not able to do it or what. Well, as the title suggests, I would like to OPen Excel in vb.net. I was able to find end number of articles online on this but none would help. It … | |
Hello-- I am not sure where I should post this. I have an Excel spreadsheet with some cells I would like to concatenate into one resulting cell. I can get the cells concatinated, but I would like to concatenate one cell to the degrees symbol, followed by a space, followed … | |
I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … | |
Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, … | |
Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at … | |
Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that … | |
I´m having some trouble with my web browsers, both internet explorer and firefox. After around ten minutes or so of use, whatever browser I am using keeps opening itself again and again and won´t stop. The pages open to the homepage. I´ve run adaware and spybot and norton, and they´ve … | |
hi everyone im really new to report viewer in vb.net and i wanto import the data from an excel file to the reportviewer in vb.net can anyone help me out? here is waht i tried so far: Private Sub ViewReport_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local … | |
Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 … | |
I have an excel file that i managed to perform some calculation.It's to know the asset value of bridges in a current year.I have 21 fields in the file.Out of the 21 fields,seven fields are just information about the bridge,the rest are used for the calculation based on various conditions.And … | |
In my Windows application, I want to create an automation software using C#.NET which works in two steps: 1. Select particular data and copy it from a page of a website. I have done it using web browser control for SelectAll. The data is not HTML data but databound data. … | |
Hi All, I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells). I tried with available report studio functions like running_total, Moving_total. I got errors. I am automating excel reports into cognos … | |
I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group … | |
helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical … | |
Hello, The code below works almost perfectly except for two flaws: 1. It provides the full name of the file (workbook.xls) instead of just "workbook" 2. If there is more than 1 worksheet then the loop appends the previous worksheet to the filename. For example, Workbook1 has 1 worksheet Workbook2 … | |
I want to import/upload excel files to sql server via cake php, it will occur Undefined variable: ext and Undefined index: the code are shown as below. Is there any mistake in my code? Thanks in advance! <?php App::import('Vendor', 'php-excel-reader/excel_reader2'); class UploadsController extends RealTimeAnalysisAppController { public function upload() { $destination … | |
i'm not sure what is the syntax error. I try in this source code in dreamweaver, it shows line 8 is a syntax error. $destination = realpath(‘../../app/webroot/uploads/excel/’); App::import(‘Vendor’, ‘php-excel-reader/excel_reader2’); //import statement class UploadsController extends RealTimeAnalysisAppController public function upload() { $destination = realpath(‘../../app/webroot/uploads/excel/’); //Set your upload path here if(isset($_FILES['Upload']['XLS_File'])); $ext = … | |
Good Morning Everyone, May i know how to extract all data from a excel file and copy the data all over to another excel file? Example from Excel A, we have data EmployeeID Name Department 1111 John MIS I want to copy the data over to Excel B... may i … | |
Hi, I have a 3-column data (below) from excel file. How can I write a perl code to sort all rows according to the first numeric number of a numeric interval and the word "complement" if they appear before the numeric interval as shown in the expeceted output below? Data: … | |
Hi All, How can I export data from gridview to excel sheet in ASP.net? | |
Was updating tags, at some point I got to this: http://www.daniweb.com/tags/tables Is this a caching issue? It's showing "usability" and "excel". I do come across tags in the tagclouds, where the link goes to the "Oops" page (e.g. http://www.daniweb.com/tags/three). Am guessing it's because I removed that tag, but the cached … | |
Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check … | |
Hi all, i encounter an syntax error "Syntax Error in Insert Into" when i try to run this code... anyone can assist? Thanks! Dim sConnectionString As String sConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "Data Source=H:\Users\Desktop\EmployeeAway2.xlsx;Extended Properties=""Excel 12.0;HDR=YES;""" Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString) objConn.Open() Dim objCmd As New System.Data.OleDb.OleDbCommand() objCmd.Connection = objConn … | |
hello thank you for your good solution but your solution always assume external workbook to be open, how to work with current opened workbook? Dim oxcel As Excel.Application Dim owb As Excel.Workbook Dim osht As Excel.Worksheet oxcel= New Excel.Application oxcel.Visible = True owb= oxcel.Workbooks.Open(Path) osht= owb.Worksheets(1) now I developing add-in … | |
When using my Toshiba laptop the screen went black for a few seconds, came back, the went black again permanently. I turned it off but when I turn it back on the Toshiba loud up screen comes on but the screen again goes black afterwards. The solution of, 'turn it … | |
Hi I am trying to upload excel file data thorugh .net uploading code. But i am getting an error message. can any one please help me to resolve this. **Upload.aspx** <%@ Page Language="C#" AutoEventWireup="true" CodeFile="add_residentupload.aspx.cs" Inherits="add_residentupload" %> <table class="table-list"> <tr> <td width="30%">Upload File</td> <td><asp:FileUpload ID="fupUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" … | |
i need to the step by steps screenshot and coding | |
can any one help me.. how to export a table echoed in php to an excel through a button ?? | |
Hi there, Thank you for accepting me within your community My name is Bernard, I'm a French-speaking Belgian citizen living and working in Thailand since December 2003. I'm not an IT expert. I've been using VBA since Excel supports it (Excel 5-1995?). I work here as a school administrator and … | |
Hi Guys, I'm new to awk and trying to format an stadout "temp.txt" to csv format so I can export to excel. I'm having issues here is my code so far..If any one can help to see the light!!! The ### sign is the second server on the list each … |
The End.