Hi I have created an excel file download feature within a .net application
using Microsoft Office XP primary interop assembly for excel. I was just
wondering if anyone knows if you can also embed excel formulas in the excel
download, for example a running total on a column, thanks.
--
Paul G
Software engineer. 7 2701
"Paul" <Pa**@discussio ns.microsoft.co mwrote in message
news:69******** *************** ***********@mic rosoft.com...
Hi I have created an excel file download feature within a .net application
using Microsoft Office XP primary interop assembly for excel.
Assuming you mean an ASP.NET application, this is a really bad idea. Even
Microsoft strongly advise against it... http://support.microsoft.com/default...US;q257757#kb2
Use this instead: http://www.aspose.com/Products/Aspos...s/Default.aspx
Also, click in the link on that page entitled "Why Not Automation?"
thanks for the response. I was thinking it could lead to problems. Just had
another quick question, I have been able to create a powerpoint app from a
..net windows application, do you know if this can be done with a .net web
application?
I need to convert this line to something that would work in a .net web app.
Do While oApp.SlideShowW indows.Count >= 1
System.Windows. Forms.Applicati on.DoEvents()
Loop
--
Paul G
Software engineer.
"Mark Rae" wrote:
"Paul" <Pa**@discussio ns.microsoft.co mwrote in message
news:69******** *************** ***********@mic rosoft.com...
Hi I have created an excel file download feature within a .net application
using Microsoft Office XP primary interop assembly for excel.
Assuming you mean an ASP.NET application, this is a really bad idea. Even
Microsoft strongly advise against it... http://support.microsoft.com/default...US;q257757#kb2
Use this instead: http://www.aspose.com/Products/Aspos...s/Default.aspx
Also, click in the link on that page entitled "Why Not Automation?"
"Paul" <Pa**@discussio ns.microsoft.co mwrote in message
news:5A******** *************** ***********@mic rosoft.com...
another quick question, I have been able to create a powerpoint app from a
.net windows application, do you know if this can be done with a .net web
application?
It *can* be done, just like creating an Excel workbook *can* be done...
It's just not recommended...
ok thanks for the information, will take a look at the aspose software.
--
Paul G
Software engineer.
"Mark Rae" wrote:
"Paul" <Pa**@discussio ns.microsoft.co mwrote in message
news:5A******** *************** ***********@mic rosoft.com...
another quick question, I have been able to create a powerpoint app from a
.net windows application, do you know if this can be done with a .net web
application?
It *can* be done, just like creating an Excel workbook *can* be done...
It's just not recommended...
"Paul" <Pa**@discussio ns.microsoft.co mwrote in message
news:68******** *************** ***********@mic rosoft.com...
ok thanks for the information, will take a look at the aspose software.
It's pretty much the industry standard...
hejdig.
Contrary to common belief there are no problems creating Excel on the
server. As long as you create it as XML.
Take your target Excel spread sheet. Save it as XML.
Open the XML in your favourite editor and deduct where to put your data.
Then either XMLTransform your data or concatenate strings to an Excel
compatible XML document.
Another way is to make the response comma separated or as a table but suffix
it xls and make the type something like application/excel. The browser
believes it is an excel document and starts excel. At leas IE6 does.
Happy hacking!
/OF - ola.fjelddahl(a t)diespammers.m andator.com
----------------
>"Paul" <Pa**@discussio ns.microsoft.co mwrote in message news:69******** *************** ***********@mic rosoft.com...
Hi I have created an excel file download feature within a .net application
using Microsoft Office XP primary interop assembly for excel. I was just
wondering if anyone knows if you can also embed excel formulas in the
excel
download, for example a running total on a column, thanks.
Paul G
Software engineer.
"LosManos" <Lo******@newsg roups.nospamwro te in message
news:u8******** ********@TK2MSF TNGP04.phx.gbl. ..
Contrary to common belief there are no problems creating Excel on the
server. As long as you create it as XML.
That's true, but not what the OP was doing...
And creating an XML document isn't "creating Excel"...
Another way is to make the response comma separated or as a table but
suffix it xls and make the type something like application/excel. The
browser believes it is an excel document and starts excel. At leas IE6
does.
As above. But that won't do formulas etc, which is what the OP was looking
for... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jeremy Langworthy |
last post by:
Hi
I am trying to create a MS Excel format CSV but I can't figure out how
to get the line feed/carriage return/new record working properly.
I am nding each line/record with these characters: "\r\n" but the
Excel file just loads all the field in one row as if it doesn't
recognise these characters.
These are the headers I am using to create the file:
|
by: Bertrand |
last post by:
Hello,
I am trying to archieve the following:
- copy an excel file present on the server
- insert values into named ranges of the copy
I am using Excel97 on my PC, the server does not have
Excel installed on it so I can't create the object
Excel.Application
|
by: JBAdamsJr |
last post by:
I want to be able to create an Excel file with a VB.NET program on a server that does not have Microsoft Excel loaded on it. I am using the Jet OLE DB to read other data files. Can this be used to save an array in an Excel .XLS format?
|
by: sandycat05 |
last post by:
Hello all, I am a new Perl programmer. Below is the beginnings of a code that I am using to manipulate an Excel spreadsheet via Perl using win32::OLE. However, what I'd like to do is the following: instead of either opening a file or creating a new one, I'd like to do BOTH. I was thinking of creating a loop where I could basically say something like:
if $excelfile exists, then open $excelfile, otherwise, create a new workbook named...
|
by: Jason |
last post by:
I am having some trouble manipulating Excel files. Currently I am
trying to create and then close an Excel file/application with the following
code. It works fine, except it leaves an EXCEL application open, which I can
see in the Task Manager. I have tried oExcel.Dispose(), but this generates
an error. How can I correct this code so that the object is properly
disposed of? Thanks!
Public Sub CreateExcelFile(Optional ByVal sFileName As...
| |
by: =?Utf-8?B?TEJU?= |
last post by:
Good Day,
I have a web application created using ASP.NET (with VB.NET). The
application allow user to browse Excel raw data file then the program will
grab data from the file to perform further data processing.
The question is I'm doing this by creating an Excel application everytime to
do the processing which in other words ActiveX object is being created. New
release of IE is blocking the ActiveX object which causes my application...
|
by: Rastra |
last post by:
Hi,
I am working on a ASP.NET project where I need to create and export data into excel format. I have done it by using Miscrosoft Componets for excel but now I need to do it without using Miscrosoft Componets for excel as server will not have MS Excel installed in it.
If any one can provided me with any type of idea or code samples for doing it would be a great help.
Thanks
|
by: =?Utf-8?B?U0NhcnRlcg==?= |
last post by:
I am working on a project where I need to create an excel file from our
ASP.Net website and have it saved on a Macintosh computer. Currently, it is
saving the .xls file just fine on the MAC, but when you go to open it, it
opens the file as a new workbook. When you go to save it, it tries to save
it as the auto-generated workbook name that excel gives to it. The problem
is that I want to be able to allow a user to import the file directly...
|
by: vijayarl |
last post by:
Hi Everyone,
Am trying to collate the individual xls files into a single xls file.i have written this code.
use strict;
use Spreadsheet::WriteExcel;
use Spreadsheet::ParseExcel;
use Spreadsheet::WriteExcel::Big;
my $consol_rows=0;
|
by: mukeshmc |
last post by:
I want create my output in excel file. But in server i cannot install office, its too costly
i am developing it with vishual studio2005 with vb.
so anybody can give the solution for this
thanks in advance
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |