Можно ли создать Объект Excel на строне Web сервера (IIS)?

Можно ли создать Объект Excel на строне Web сервера (IIS)
непример, как-нибудь так:

Variant XL = CreateOleObject('Excel.Application');
XL.OlePropertySet('Visible', true);
XL.OlePropertySet('Caption', 'MyReport');
XL.OlePropertySet('DisplayAlerts', false);
Variant books = XL.OlePropertyGet('Workbooks');
books.OleProcedure('Add');
....

0

Пример кода, как создать Word class. Excel - аналогично.

Good luck!
=====================================
using System;
using System.ComponentModel;

namespace WordApplication
{
/// <summary>
///
/// </summary>
///

public class CCWordApp
{
private Word.ApplicationClass oWordApplic; // a reference to Word application
private Word.Document oDoc; // a reference to the document


public CCWordApp()
{
// activate the interface with the COM object of Microsoft Word
oWordApplic = new Word.ApplicationClass();
}

// Open a file (the file must exists) and activate it
public void Open( string strFileName)
{
object fileName = strFileName;
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;

oDoc = oWordApplic.Documents.Open(ref fileName, ref missing,ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref isVisible,ref missing,ref missing,ref missing);

oDoc.Activate();
}

// Open a new document
public void Open( )
{
object missing = System.Reflection.Missing.Value;
oDoc = oWordApplic.Documents.Add(ref missing, ref missing,ref missing, ref missing);

oDoc.Activate();
}



public void Quit( )
{
object missing = System.Reflection.Missing.Value;
oWordApplic.Application.Quit(ref missing, ref missing, ref missing);
}

public void Save( )
{
oDoc.Save();
}

public void SaveAs(string strFileName )
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;

oDoc.SaveAs(ref fileName, ref missing,ref missing, ref missing,ref missing,ref missing,ref missing,
ref missing,ref missing,ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}

// Save the document in HTML format
public void SaveAsHtml(string strFileName )
{
object missing = System.Reflection.Missing.Value;
object fileName = strFileName;
object Format = (int)Word.WdSaveFormat.wdFormatHTML;
oDoc.SaveAs(ref fileName, ref Format,ref missing, ref missing,ref missing,ref missing,ref missing,
ref missing,ref missing,ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
}



public void InsertText( string strText)
{
oWordApplic.Selection.TypeText(strText);
}

public void InsertLineBreak( )
{
oWordApplic.Selection.TypeParagraph();
}
public void InsertLineBreak( int nline)
{
for (int i=0; i<nline; i++)
oWordApplic.Selection.TypeParagraph();
}

// Change the paragraph alignement
public void SetAlignment(string strType )
{
switch (strType)
{
case 'Center' :
oWordApplic.Selection.ParagraphFormat.Al ignment = Word.WdParagraphAlignment.wdAlignParagra phCenter;
break;
case 'Left' :
oWordApplic.Selection.ParagraphFormat.Al ignment = Word.WdParagraphAlignment.wdAlignParagra phLeft;
break;
case 'Right' :
oWordApplic.Selection.ParagraphFormat.Al ignment = Word.WdParagraphAlignment.wdAlignParagra phRight;
break;
case 'Justify' :
oWordApplic.Selection.ParagraphFormat.Al ignment = Word.WdParagraphAlignment.wdAlignParagra phJustify;
break;
}

}

// if you use thif function to change the font you should call it again with
// no ction.MoveRight Unit:=wdCell

object missing = System.Reflection.Missing.Value;
object direction;
direction = Word.WdUnits.wdLine;
oWordApplic.Selection.MoveUp(ref direction,ref missing,ref missing);
}


// this function doesn't work
public void InsertPageNumber( string strType, bool bHeader )
{
object missing = System.Reflection.Missing.Value;
object alignment ;
object bFirstPage = false;
object bF = true;
//if (bHeader == true)
//WordApplic.Selection.HeaderFooter.PageNu mbers.ShowFirstPageNumber = bF;
switch (strType)
{
case 'Center':
alignment = Word.WdPageNumberAlignment.wdAlignPageNu mberCenter;
//WordApplic.Selection.HeaderFooter.PageNu mbers.Add(ref alignment,ref bFirstPage);
//Word.Selection objSelection = WordApplic.pSelection;

oWordApplic.Selection.HeaderFooter.PageN umbers.Item(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNu mberCenter;
break;
case 'Right':
alignment = Word.WdPageNumberAlignment.wdAlignPageNu mberRight;
oWordApplic.Selection.HeaderFooter.PageN umbers.Item(1).Alignment = Word.WdPageNumberAlignment.wdAlignPageNu mberRight;
break;
case 'Left':
alignment = Word.WdPageNumberAlignment.wdAlignPageNu mberLeft;
oWordApplic.Selection.HeaderFooter.PageN umbers.Add(ref alignment,ref bFirstPage);
break;
}

}

}
//object units = WdUnits.wdCharacter;
//object last=doc.Characters.Count;
//doc.Range(ref first, ref last).Delete(ref units, ref last)
}

0

Большое спасибо.

0

Нема за що.

0