2월, 2015의 게시물 표시

java read file line by line using bufferedreader

http://www.programcreek.com/2011/03/java-read-a-file-line-by-line-code-example/

How to check whether excel file is already opened with C#

Excel.Application oExcelApp; using Excel = Microsoft.Office.Interop.Excel; .... .... Excel.Workbook xlwkbook = (Excel.Workbook)System.Runtime.InteropServices.Marshal.BindToMoniker(@"C:\temp\book1.xlsx"); //True : already opened by human. False : not opened by human bool isOpened = xlwkbook.Application.Windows["book1.xlsx"].Visible; Trace.WriteLine(isVis);

Clean up COM object

http://stackoverflow.com/questions/158706/how-to-properly-clean-up-excel-interop-objects/159419#159419

How to use Visual C# to automate a running instance of an Office program

http://support2.microsoft.com/default.aspx?scid=kb;EN-US;316126             Excel.Application oExcelApp;             Excel.Workbook xlwkbook = (Excel.Workbook)System.Runtime.InteropServices.Marshal.BindToMoniker(@"C:\temp\booke1.xlsx");             Excel.Worksheet s = xlwkbook.ActiveSheet;             Range x = s.Cells[2, 1];             x.Value = "bbcccccbbbb";             MessageBox.Show(xlwkbook.Path);             //xlwkbook.Save();             //Release the reference.             oExcelApp = null;