|
ok. thx. would be another idea to split the long sequence into seperate functions. but i have to use a lot of variables in all of the parts of this long sequence - so splitting it up would result in a lot of !=null testing of class-members which only have the task to pass data from one private function to another ... 
hmm. too much overhead in the code i think...
but thx anyway for the idea 
:wq
|
|
|
|
|
Hi ,
How to access an EXCEL File and read the cells within it?
Can anyone show me a light?
thanks in advance
|
|
|
|
|
I never write c# code, but In c++ or java, I ever had access Excel, send the c++ codes, hope some help to you!
----------------------------------------------------------
package snsoftx.win;
import snsoft.util.*;
import com.jacob.com.*;
import com.jacob.activeX.*;
import java.util.*;
import java.io.File;
/**
* Company: 南北公司
* @author: Grant
* @email: wang_yi_ming@263.net
* @version 5.0
*
* MSExcelApp类用来操作Ms Excel文件:
* 新建，删除文件, Sheet, Row, Col
* comments:
* 要使用MSExcelApp类, 必须jacob.dll的支持
*
* expamples:
* 1. 只读打开文件,读数据:
* MSExcelApp excelApp = null;
* try
{
excelApp = new MSExcelApp();
if( excelApp.openExcel("c:\\temp\\cc.xls","Sheet1") )
{
int rowCount = excelApp.getRowCount();
int colCount = excelApp.getColumnCount();
System.out.println("rowCount=" + rowCount+",colCount=" + colCount);
// get column info
for (int col = 0; col < colCount; col++)
System.out.println("colName:" + excelApp.getColumnName(col) + "\r\n");
excelApp.prepareFetchData(); // 为了提高查询速度
for (int r = 0; r < rowCount; r++)
{
excelApp.gotoRow( r );
for (int c = 0; c < colCount; c++)
{
Object ob = excelApp.getValue(c);
// or ob = excelApp.getCellValue(r,c);
s += (ob == null) ? "" : ob.toString() + ",";
}
System.out.println(s + "\r\n");
}
excelApp.endFetchData();
excelApp.close();
}
}
catch (Exception ex) { ex.printStackTrace(); }
* 2. 打开文件,修改文件 :
* MSExcelApp excelApp = null;
* try
{
excelApp = new MSExcelApp();
if( excelApp.openExcel("c:\\temp\\cc.xls","学生成绩单",false,false,true) )
{
excelApp.addField("学号",0)
excelApp.addField("姓名",0)
excelApp.addField("语文",1)
excelApp.addField("数学",1)
excelApp.addField("英语",1)
excelApp.insertRow(true);
excelApp.setValue(0,"01");
excelApp.setValue(1,"张三");
excelApp.setValue(2,new Double("85.0") );
excelApp.setValue("数学",new Double("95.0") );
excelApp.setValue(4,new Double("90.5") );
excelApp.insertRow(true);
excelApp.setValue(0,"02");
excelApp.setValue(1,"李四");
excelApp.setValue(2,new Double("80.0") );
excelApp.setValue(3,new Double("90.0") );
excelApp.setValue(4,new Double("85.5") );
excelApp.saveChanges(); // 保存
excelApp.close();
}
}
catch (Exception ex) { ex.printStackTrace(); }
*
*/
public class MSExcelApp // extends AbstractDataSet
{
public ActiveXComponent excelApp;
private Dispatch workbooks;
private Dispatch workbook; // private Dispatch sheets;
private Dispatch sheet;
String m_szFileName;
String m_szSheetName;
boolean m_bNewFile;
boolean m_bReadOnly;
boolean m_bValidate;
boolean bPreparedFectch;
int rowCount, colCount;
int curRow;
Vector fldNames = new Vector();
boolean bCreateFile = false;
boolean visible;
public MSExcelApp()
{
this( false );
}
public MSExcelApp(boolean visible)
{
this.visible = visible;
}
/**
* Open for readOnly
*/
public boolean openExcel(String szFileName,String szSheetName)
{
return openExcel( szFileName,szSheetName, false,false,false);
}
public boolean openExcel(String szFileName,String szSheetName,boolean bReadOnly)
{
return openExcel(szFileName, szSheetName, bReadOnly,false,false);
}
public boolean openExcel(String szFileName,String szSheetName,
boolean bReadOnly, boolean bNewFile, boolean bNewSheet)
{
if( excelApp == null )
{
excelApp = new ActiveXComponent("Excel.Application");
if( visible )
excelApp.setProperty("Visible", new Variant(true));
}
workbooks = Dispatch.get(excelApp,"Workbooks").toDispatch();
bPreparedFectch = false;
curRow = -1;
rowCount = colCount = 0;
if( szFileName.indexOf('/') >= 0 )
szFileName = szFileName.replace('/','\\');
m_szFileName = szFileName;
m_bReadOnly = bReadOnly;
m_bNewFile = bNewFile;
try
{
// if( bNewFile
if( !bNewFile && isFileExist(szFileName) )
{
workbook = Dispatch.call(workbooks,"Open",szFileName).toDispatch();
m_bValidate = true;
}
else
{
workbook = Dispatch.call(workbooks,"Add").toDispatch();
bCreateFile = true;
m_bValidate = true;
}
if( bNewSheet && !isSheetExist(szSheetName) )
m_bValidate = newSheet( szSheetName );
else
{
m_bValidate = activeSheet( szSheetName );
if( m_bValidate )
{
innerGetRowColCount();
//PrepareFetchData();
for(int i=0; i<colcount; i++)
="" fldnames.addelement(="" innergetcolumnname(i)="" );
="" endfetchdata();
="" }
="" catch(exception="" ex)
="" {
="" m_bvalidate="false;
" ex.printstacktrace();
="" return="" m_bvalidate;
="" }
="" public="" boolean="" isfileexist(="" string="" szfilename="" )
="" try
="" file="" file(szfilename);
="" file.isfile();
="" ex)="" {}
="" false;
="" }
="" safearray="" sa;
="" int="" nametoindex(string="" szfldname)
="" for(int="" i="0;" i<fldnames.size();="" if(="" fldnames.elementat(i).tostring().equalsignorecase(="" szfldname="" )="" i;
="" -1;
="" addfield(string="" szcolname,="" ncoltype)
="" setcellvalue(-1,="" colcount,="" szcolname)="" szcolname="" set="" column="" attribute
="" *
="" selection.numberformatlocal="@"
="" *="" szformat="@" ;
="" if="" (="" ncoltype="=" com.borland.dx.dataset.variant.int="" ||="" com.borland.dx.dataset.variant.short
="" com.borland.dx.dataset.variant.byte="" com.borland.dx.dataset.variant.long="" else="" com.borland.dx.dataset.variant.bigdecimal="" com.borland.dx.dataset.variant.float="" com.borland.dx.dataset.variant.double="" com.borland.dx.dataset.variant.date="" com.borland.dx.dataset.variant.timestamp="" ;
="" colname="getCellColName(colCount);
//Message.out.println(colName+","+szColName+","+szFormat);
" object="" a1="Dispatch.invoke(sheet," "columns",="" dispatch.get,
="" new="" object[]="" {colname+":"+colname},
="" int[1]).todispatch();
="" end
="" dispatch.put(="" a1,="" "numberformatlocal",="" szformat);
="" colcount++;
="" true;
="" else
="" getcolumnname(int="" col)
="" col="">=0 && col < fldNames.size() )
return fldNames.elementAt(col).toString();
return "";
}
public int getColumnType(int col) { return 0; }
protected String getCellColName(int col)
{
col++;
int count = 0;
String s = "";
while( col > 0 )
{
int m = (col-1)%26;
col = (col-1)/26;
s = (char)('A'+m) + s;
}
return s;
}
protected String getCellName(int row, int col)
{
return getCellColName(col)+(row+2);
}
// zsb 11-29 cancel
/* static public void closeExcelApp()
{
if( excelApp != null )
{
Dispatch workbook = Dispatch.get(excelApp,"ActiveWorkbook").toDispatch();
Dispatch.call(workbook,"Close", new Variant(false) );
excelApp.invoke("Quit", new Variant[] {});
excelApp.release();
excelApp = null;
}
}
*/
public void close()
{
fldNames.removeAllElements();
if( excelApp != null && workbook != null )
{
endFetchData();
Dispatch.call(workbook,"Close", new Variant(false) );
workbook = null;
excelApp.invoke("Quit", new Variant[] {});
excelApp.release();
excelApp = null;
}
}
public String getFileName()
{
return m_szFileName;
}
boolean isReadOnly() { return m_bReadOnly; };
public void prepareFetchData()
{
if( !bPreparedFectch )
{
String cell1 = getCellName(-1,0);
String cell2 = getCellName(rowCount,colCount);
Dispatch range = Dispatch.invoke(sheet, "Range", Dispatch.Get,
new Object[] {cell1+":"+cell2},
new int[1]).toDispatch();
Variant ret = Dispatch.get(range,"Value");
sa = ret.toSafeArray();
bPreparedFectch = true;
}
}
public void endFetchData()
{
if( bPreparedFectch )
{
if( sa != null )
{
sa.release();
sa = null;
}
bPreparedFectch = false;
}
}
boolean activeSheet(String szSheetName)
{
// Dispatch workbook = Dispatch.get(excelApp,"ActiveWorkbook").toDispatch();
Dispatch sheets = Dispatch.get(workbook,"Sheets").toDispatch();
int count = Dispatch.get(sheets,"Count").toInt();
for(int i=0; i<count; i++)
="" {
="" sheet="Dispatch.call(sheets," "item",="" new="" variant(i+1)).todispatch();
="" if(="" szsheetname.equalsignorecase(="" dispatch.get(sheet,"name").tostring()="" )="" )
="" dispatch.call(sheet,"activate");
="" return="" true;
="" }
="" false;
="" }
="" boolean="" issheetexist(string="" szsheetname)
="" dispatch="" workbook="Dispatch.get(excelApp,"ActiveWorkbook").toDispatch();
" sheets="Dispatch.get(workbook,"Sheets").toDispatch();
" int="" count="Dispatch.get(sheets,"Count").toInt();
" for(int="" i="0;" i<count;="" deletesheet(string="" variant(i+1)).todispatch();
="" try
="" dispatch.call(sheet,"delete");
="" catch(exception="" ex)="" {="" break;="" newsheet(string="" message.out.println("new="" sheet"+szsheetname);
="" "add").todispatch();
="" dispatch.put(sheet,"name",szsheetname);
="" ex)
="" protected="" void="" finalize()="" throws="" throwable="" close();="" public="" getrowcount()
="" rowcount;
="" getcolumncount()
="" colcount;
="" getrow()
="" currow;
="" gotorow(int="" row)
="" row="">=0 && row < rowCount )
curRow = row;
}
public Object getValue(int row,int columnIndex)
{
return getCellValue(row, columnIndex);
}
public Object getValue(int columnIndex)
{
return getCellValue(curRow, columnIndex);
}
public void insertRow(boolean after)
{
if( m_bReadOnly || !m_bValidate )
return;
try
{
if( !after )
curRow = rowCount++;
else
{
String cell1 = getCellName(curRow,0);
String cell2 = getCellName(curRow,colCount-1);
Dispatch range = Dispatch.invoke(sheet, "Range", Dispatch.Get,
new Object[] {cell1+":"+cell2},
new int[1]).toDispatch();
// value = Dispatch.get(a1, "Value");
//Dispatch range = Dispatch.call(excelApp,"GetRange", new Variant(cell1),new Variant(cell2) ).toDispatch();
boolean bRet = Dispatch.call(range,"Insert", new Variant( (long)-4121 )).toBoolean();
if( bRet )
rowCount++;
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public void postRow()
{
if( m_bReadOnly || !m_bValidate || excelApp == null )
return ;
try
{
// Dispatch workbook = Dispatch.get(excelApp,"ActiveWorkbook").toDispatch();
if( bCreateFile )
Dispatch.call(workbook,"SaveAs",m_szFileName);
else
Dispatch.call(workbook,"Save");
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
public boolean isRowChanged()
{
return false;
}
public boolean isNewRow()
{
return false;
}
public boolean deleteIndexRow(int row)
{
if( m_bReadOnly || !m_bValidate || row >= rowCount || row < 0 )
return false;
boolean bRet = false;
try
{
// Dispatch range = Dispatch.call(excelApp,"GetRange", GetCellName(row,0), GetCellName(row,colCount-1) ).toDispatch();
Dispatch range = Dispatch.invoke(sheet, "Range", Dispatch.Get,
new Object[] { getCellName(row,0), getCellName(row,colCount-1) },
new int[1]).toDispatch();
bRet = Dispatch.call(range, "Delete", new Variant( (long)-4162 )).toBoolean();
}
catch(Exception ex) { }
if( bRet )
{
rowCount--;
if( curRow >= rowCount )
curRow = rowCount-1;
}
return bRet;
}
public void deleteRow()
{
deleteIndexRow(curRow);
}
public void saveChanges()
{
postRow();
}
/*
public boolean isChanged()
{
return false;
}
public boolean find(int findType,String filter)
{
return false;
}
public boolean find(String filter)
{
return false;
}
public boolean findNext(String filter)
{
return false;
}
public boolean seek(String comparision,Object keys[])
{
return false;
}
public void setCurrentIndex(String indexName)
{
}
*/
public boolean gotoFirst()
{
curRow = 0;
return rowCount > 0;
}
public boolean gotoLast()
{
curRow = rowCount-1;
return rowCount > 0;
}
public boolean gotoNext()
{
if( curRow < rowCount-1 )
{
curRow++;
return true;
}
return false;
}
public boolean gotoPrev()
{
if( curRow > 0 )
{
curRow--;
return true;
}
return false;
}
public void edit()
{
}
public void update()
{
postRow();
}
void innerGetRowColCount()
{
rowCount = colCount = 0;
if( !m_bValidate ) return;
Dispatch range = Dispatch.get(excelApp, "ActiveCell").toDispatch();
range = Dispatch.call(range, "SpecialCells", new Variant(11)).toDispatch();
Dispatch.call(range,"Select");
rowCount = Dispatch.get(range, "Row").toInt() - 1;
colCount = Dispatch.get(range, "Column").toInt();
}
String innerGetColumnName(int col)
{
Object o = getCellValue(-1,col);
return ( o == null ) ? "" : o.toString();
}
public Object getCellValue(int row, int col)
{
Object value = null;
if( m_bValidate && row >= -1 && col >= 0 && row < rowCount && col < colCount )
{
try
{
if( bPreparedFectch && sa != null )
value = sa.getVariant(row+2,col+1);
else
{
String cellName = getCellName(row,col);
Object a1 = Dispatch.invoke(sheet, "Range", Dispatch.Get,
new Object[] {cellName},
new int[1]).toDispatch();
value = Dispatch.get(a1, "Value");
}
}
catch(Exception ex){ ex.printStackTrace(); }
}
Variant vTemp =(Variant)value;
if (vTemp.isNull())
value=null;
return value;
}
public boolean setCellValue(int row, int col,Object val)
{
if( !m_bValidate || m_bReadOnly )
return false;
if( row >= -1 && col >= 0 )
{
try
{
String cellName = getCellName(row,col);
Object a1 = Dispatch.invoke(sheet, "Range", Dispatch.Get,
new Object[] {cellName},
new int[1]).toDispatch();
String text;
if( val == null )
text = "";
else if( val instanceof java.util.Date )
text = snsoft.util.Utilities.dateToString((java.util.Date)val);
else
text = val.toString();
Dispatch.put( a1, "FormulaR1C1", text); // Dispatch.put( a1, "Value", text);
return true;
}
catch(Exception ex) {}
}
return false;
}
public void setValue(int columnIndex,Object value)
{
setCellValue(curRow, columnIndex, value);
}
public void setValue(String colName,Object value)
{
setCellValue(curRow, nameToIndex(colName), value);
}
public static boolean newExcelSheet(String szFileName, String szSheetName)
{
boolean bFileExist = false;
try
{
File file = new File(szFileName);
bFileExist = file.isFile();
}
catch(Exception ex) { }
MSExcelApp excel = new MSExcelApp();
if( excel.openExcel(szFileName,szSheetName,true,bFileExist,true) )
{
try { excel.update(); return true; } catch(Exception ex) { return false; }
}
else
return false;
}
public static boolean isSheetExist(String szFileName, String szSheetName)
{
MSExcelApp excel = new MSExcelApp();
boolean bRet = excel.openExcel(szFileName,szSheetName,false);
excel.close();
return bRet;
}
public static boolean deleteSheet(String szFileName, String szSheetName)
{
MSExcelApp excel = new MSExcelApp();
if( excel.openExcel(szFileName,szSheetName, true) && excel.deleteSheet(szSheetName) )
{
try { excel.postRow(); return true; } catch(Exception ex) { return false; }
}
else
return false;
}
};
|
|
|
|
|
Hi
How do I set a Form so it will not receive focus when shown on the screen, - or how do I free/loose the focus after I got it ? 
Ok, what I want is to display a notification like the one in MSN messenger, - and I got a timer running where I check for messages. When messages arrive I'm able to show a little form with the message.
The problem is that when the message is shown, my form receives focus and any other program I'm working in looses it - which is very anoying !
Hope somebody can help.
Regards
Bo
|
|
|
|
|
Hmm, seems that setting the property TopMost to false does the trick, but this leads me to a new question ...
How do I change the Z-order of windows on the Desktop so my message window is not the hidden by all other open windows ?
Preferrable a solution without giving my application focus, or at least limit the focus to micro seconds. The method BringToFront() does not do the trick 
It's OK that the message is hidden by the current active window, but I would like the message to get in front of other inactive windows.
Regards
Bo
|
|
|
|
|
Hi all,
I'm working with the EventLog class, but when i call the WriteEntry method it always set the user (in the Event Viewer) to N/A.
Where can i specify the user to the EventLog???
Thanks
Vanclei Matheus
Brazil
MSN Msgr - vmatheus@msn.com
|
|
|
|
|
Hi,All
I want to call a function in DLL whose prototype is
int SomeFunction(int,void*,int);
In C# i want to pass the address of char array(e.g. unsigned char data[4000];)
to it.
so i write the unsafe code like this:
char[] data = new char[4000];
SomeFunction(,&data,);
but it gives the error
"Cannot take the address or size of a variable of a managed type('Char[]')
how should i pass the address of a char array to this function?
Thanks in advance
Tushar
|
|
|
|
|
unsafe
{
char [] data = new char[4000];
fixed(char* pData = &data)
{
SomeFunction(0, (void*) pData, 0);
}
}You have to use the fixed statement so that if a GC happens it won't move the memory around on you
James
"Java is free - and worth every penny." - Christian Graus
|
|
|
|
|
|
Cmon, some one MUST be able to answer this one  ....
I've finally figured out how to use 32 bit images in an image list. Now, now what program can I use to generate 32-bit bmp or ico files? I'm still using Visual Studio 6, and I have my icons as Corel Photopaint cpt files, but I can also save them as png or psd.
Any thoughts?
Thanx,
swinefeaster
Check out Aephid Photokeeper, the powerful digital
photo album solution at www.aephid.com.
|
|
|
|
|
Windows XP Technical Articles
Creating Windows XP Icons
July 2001
ON MSDN
ms-help://MS.VSCC/MS.MSDNVS/dnwxp/html/winxpicons.htm
Sorry dont have web link 
I did download an excellent shareware program called Icon Workshop 5 about a week ago, but I cant remember link and don't have the program at work as of yet. Will post link later.
READ MSDN
|
|
|
|
|
that link www.axialis.com check it out
READ MSDN
|
|
|
|
|
Thank you leppie! Now I can finally convert 32-bit pngs to bmps. Woohoooo!
I tried playing with that axialis icon editor, and the transparency stuff is rather cumbersome Corel Photopaint is much better for that kind of stuff, even though it's not really an icon editor. Unfortunately it doesn't natively save bmp files!
anyways, enough ranting...
cheers,
swinefeaster
Check out Aephid Photokeeper, the powerful digital
photo album solution at www.aephid.com.
|
|
|
|
|
have you tried exporting instead of saving?
|
|
|
|
|
I am looking for a windows explorer like c# control.
Could anybody give me a tip ?
Thanx
|
|
|
|
|
Treeview on left and listview on right with a splitter bar in between?
What else are you looking for?
Cheers,
Simon
"Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002)
|
|
|
|
|
A ready to use treeview with directory tree and icons
A ready to use listview with directory file infos and icons
just a ready to use control wich acts like the windows explorer, but as controls in my form.
Got an idea ?
Thanks
|
|
|
|
|
This event is being fired even when I change the selected index in the combo box in my code, by doing this for example:
comboBox.SelectedItem = "abc";
But I want an event to fire only when the user changes the selection, by using the mouse or keyboard etc. Is this possible?
|
|
|
|
|
Its not possible; but you can work around it. Create a private variable, before you alter the index set it to true; after you set the index set it to false.
In your event handler check that variable to see if it is true; if it is then you can be pretty sure that it was your program that changed the selection and not the user.
HTH,
James
"Java is free - and worth every penny." - Christian Graus
|
|
|
|
|
Thanks, thats a nice way around it and I was using that method for a while when I came across another event in the ComboBox - SelectionChangeCommitted - and this one does seem to only trigger when the user makes a selection in the list box part of the combo. Just FYI for anyone out there.
|
|
|
|
|
I call this function to remove the last item in a listview in details view. The problem is that the control is on a tab page, and if i call this function before the control has been viewed(ie. before the tab page with this control is shown), this function fails with the inner exception of message "Object reference not set to an instance of an object", and, the regular exception of "unable to create handle". This only happens if the control is not viewed first. Can someone help me out here.
public void RemoveLastItem()
{
int index = Items.Count;
try {
Items.RemoveAt(index-1);
}
catch(OutOfMemoryException e){ // Error is caught here!! Why ????
#if DEBUG
MessageBox.Show(e.InnerException.Message);
#endif
}
catch(NullReferenceException e){
#if DEBUG
MessageBox.Show(e.Message);
#endif
}
}
|
|
|
|
|
Brandon,
have you tried instantiating the listView control. if your in the same class you should be able to use "this". if your in another class you should be able to get to the listView by creating a new instance of that class if you haven't already and get to the listView that way.
MyClass cl = new MyClass()
cl.MylistView....
when i add: here parameter is an ArrayList and this code sits in a foreach
ListViewItem item = new ListViewItem(parameter);
item.SubItems.Add("");
this.listView_Parameters.Items.Add(item);
i'd expect Remove() would be the opposite.
hope i didn't state the obvious
Orion
|
|
|
|
|
Yes you have stated the obvious;P Remember I said this only occures when the tabpage that hold the listview control isnt first viewed. The listview is created along with that tabpage in the forms constructor so it is instantiated. Im thinking somehow that the items in the view control arent actually created until they are needed(ie. when the control is viewed). But, the truth is im not sure what is going on.
|
|
|
|
|
What happens if you call CreateControl() on the ListView in the constructor; this forces the control to create itself instead of delaying until it feels it is best to do so (ie when you view that tab for the first time).
James
"Java is free - and worth every penny." - Christian Graus
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
