Voir le texte source

But there are a number of neat lessons which I designed for file technique navigation  [http://www.iamsport.org/mod/blog/?username=energy7mouth Automating MS Excel Using Visual Studio.NET] utilizing threads. I will not get as well a lot into the Excel item model, very first because it is a large process, and  [http://www.dailystrength.org/people/3190737/journal/6924463 ASP Internet for Mobile Internet site Growth Together With Microsoft Visual Studio 2010] second because there is previously documentation accomplished by Microsoft. This will list all Component names  [http://sleep6whorl.livejournal.com/742.html Microsoft Visual Studio - Deciding on Which Edition of Visual Studio to Adopt] which are accessible on your machine. private item vk_origin                        = vk_missing

private object vk_delimiter                        = vk_missing

non-public item vk_editable                        = vk_bogus

non-public item vk_notify                        = vk_untrue

personal item vk_converter                        = vk_missing

personal object vk_insert_to_mru                    = vk_bogus

non-public item vk_local                            = vk_fake

personal object vk_corrupt_load                    = vk_fake#endregion

#location Close WORKBOOK VARIABLES

non-public item vk_save_changes        = vk_fake

non-public object vk_route_workbook     = vk_untrue#endregion

///

/// Vahe Karamian - 03/04/2005 - Excel Item Constructor.

///

public VkExcel()



this.startExcel()



///

/// Vahe Karamian - 03/04/2005 - Excel Item Constructor

/// noticeable is a parameter, possibly Accurate or Fake, of type item.

///

/// Obvious parameter, real for visible, bogus for non-visible

general public VkExcel(bool visible)



this.vk_app_visible = noticeable

this.startExcel()



...In the previously mentioned block, we have predefined some constants that will be used to open a given Excel file. To discover out far more about what each and every parameter represents or does, you ought to seem into the documentation that comes with Excel.

We have two constructors: VkExcel() which by default will begin Excel concealed, and the other VkExcel(bool noticeable) which gives you the selection to specify if you would like to see the Excel software or not.

...

///

/// Vahe Karamian - 03/04/2005 - Start off Excel Software

/// #location Start off EXCEL

non-public void startExcel()



if( this.excelApp == null )



this.excelApp = new Excel.ApplicationClass()



// Make Excel Obvious

this.excelApp.Obvious = this.vk_app_obvious

#endregion

///

/// Vahe Karamian - 03/23/2005 - Get rid of the recent Excel Procedure

/// #location Quit EXCEL

community void stopExcel()



if( this.excelApp != null )



Process[] pProcess

pProcess = Technique.Diagnostics.Process.GetProcessesByName("Excel")

pProcess[].Kill()



#endregion

...The earlier mentioned code starts and stops the Excel Application. startExcel() checks to see if the excelApp item is initialized or not, if it is then just make confident its visibility is established to the seen home. If not, it goes forward and initializes the item for us. stopExcel() also checks to see if the object is at present in use, and if it is then it will go ahead and eliminate the approach.

Note: pProcess[].Kill() will make confident that Excel is long gone for good! Some people that do Excel automation often complain that following they stop the software, Excel disappears but the Excel procedure is nevertheless in the task monitor, this code will consider treatment of that for you!

...

///

/// Vahe Karamian - 03/09/2005 - Open up File function for Excel 2003

/// The pursuing perform will get in a filename, and a password

/// related, if required, to open up the file.

/// #location Open up FILE FOR EXCEL

public string OpenFile(string fileName, string password)



vk_filename = fileName

if( password.Length &gt  )



vk_password = password



try



// Open a workbook in Excel

this.excelWorkbook = this.excelApp.Workbooks.Open(

fileName, vk_update_back links, vk_read_only, vk_structure, vk_password,

vk_write_res_password, vk_overlook_read_only_recommend, vk_origin,

vk_delimiter, vk_editable, vk_notify, vk_converter, vk_include_to_mru,

vk_local, vk_corrupt_load)



capture(Exception e)



this.CloseFile()