|
by: Nick Carter |
last post by:
The following C# lines of code work fine with Excel 2000:-
ExcelApplication excelApplication = new Excel.Application();
ExcelWorkbook excelWorkbook =
excelApplication.Workbooks.Add(System.Reflection.Missing.Value);
The second line fails when it is rebuilt with the Excel 97 type library and
run on Excel 97. The error is an...
|
by: touf |
last post by:
Hi,
I've an error when I declare
Dim oBook As Excel.Workbooks
What imports, and reference do I need to use Excel.Workbooks class?
Thanks
|
by: msnnews.msn.com |
last post by:
hi there,
i've got a form that populates a datagrid, and a button that calls a
function to export to an excel file.
All is well with the export, no errors are returned, but the Excel instance
doesnt want to terminate properly even when i set excelApp.Quit, and
excelApp = nothing.
has anyone else experienced a problem like this???
code...
|
by: Steven |
last post by:
Hello,
I use the following code to make an Excel-file, which works fine with
Excel 2003 (and the MS Excel 11.0 object library):
Dim Excel As New Excel.Application
Dim oBook As Excel.Workbook
Dim WSheet As New Excel.Worksheet
WSheet = Excel.Workbooks.Add.Worksheets.Add
|
by: John Walker |
last post by:
Hello,
Below is my code for exporting a datagrid to Excel. It works fine, but
we're going to need to somehow have a report header, user input parameters
and system date display at the top of the spreadsheet just to make it look
like a nice little report. Is there a way that this can be done?
Thanks!
John
Private Sub Page_Load(ByVal...
|
|
by: John Walker |
last post by:
Hello,
Below is my code for exporting a datagrid to Excel. It works fine, but
we're hoping to format the output as well - setting the font size and type,
and giving each column a specific width, possibly bolding some text.
Currently we are using a macro to do this, but we would like the report to be
formatted when it's generated so that a...
|
by: jmalvika |
last post by:
Hi all,
I'm trying to generate an excel report from an ASP web page using ..
"response.ContentType = "application/vnd.ms-excel" ....
I need to add a custom header & footer to the excel report on
generation. Is there a way to do this from the web without installing
Excel on the webserver? ..
|
by: strider |
last post by:
I have struggled with this problem and the solution is that you have to
declare a variable for each and every object or collection within the
Excel application that you want to use:
For example:
Dim oExcel As Excel.Application = New Excel.Application
Dim lWorkBooks As Excel.Workbooks = oExcel.Workbooks
Dim lWorkBook As Excel.Workbook =...
|
by: james |
last post by:
Hi all, I am trying to convert some old VB6 code to .NET.
Take this first section (there is more, but hey-ho...)
Dim XLApp As Object
Dim XLSheet
Dim XLBook
Dim HeaderItem As String
Dim ColCount As Integer
ColCount = 1
Set XLApp = CreateObject("EXCEL.Application")
|
by: JFKJr |
last post by:
Hello everyone, the following is the code which opens an excel file and creates a toolbar button.
And, when I click the toolbar button as shown at line #28, the code should call the "Example" macro. But, it is displaying "The Macro "Example" cannot be found" Message Box.
Can anyone suggest an idea on how to call the macro whenever a user...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|