| ²é¿´: 461 | »Ø¸´: 5 | |||
| µ±Ç°Ö÷ÌâÒѾ´æµµ¡£ | |||
| µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû | |||
chenzilongгæ (³õÈëÎÄ̳)
|
[½»Á÷]
¡¾ÇóÖú¡¿ÈçºÎÅúÁ¿µØ½«¼ÙexcelÎļþת±äÎªÕæexcelÎļþ£¿¡¾ÒÑÍê½á¡¿
|
||
|
ÃèÊö£º½«¼ÙexcelÎļþת±äÎªÕæexcelÎļþ£¬ÏÖͨ¹ýexcelµÄºêʵÏÖ¡£µ«ÊÇ£¬Ã¿´¦ÀíÒ»¸öÎļþ£¨Ò»¸ö¹ÉƱһÌìµÄ½»Ò×Êý¾Ý£©£¬Ðè°´Ò»´ÎºêµÄ¿ì½Ý¼ü£¬·ÑÁ¦£¬ÄÜ·ñÒ»´ÎÐÔ´¦Àí¶à¸öÎļþ£¨Èç500¸ö£©£¿ÁíÍ⣬Èç¹ûÄÜÒ»´ÎÐÔ´¦Àí¶à¸ö¹ÉƱµÄ¶à¸öÎļþ£¨Èç50¸ö¹ÉƱ£¬Ã¿¸ö¹ÉƱ200¸öÎļþ£©£¬Ôò¸üºÃ¡£×¢£ºMATLAB½ö¿É¶ÁÕæexcelÎļþ ¼ÙexcelÎļþÒÔ¡°Áí´æÎª¡±·½Ê½×ª±äÎªÕæexcelÎļþ£º ÏÈÓÃdos¶ÔÄ¿±êÎļþ¼ÐÖеÄÎļþÃû³Æ½¨Á¢fname.txt£¬È»ºóÓÃexcel´ò¿ª£¬ÔÚÆäÖбà¼ÒÔϺêÎļþ£¬²Ù×÷¼´¿É¡£×¢£ºÎļþÒÔͬÃûÁí´æÎªÐÂĿ¼aÏ¡£ Sub Macro1() Dim ff As String ff = "E:\datachen\600009\" & ActiveCell.Text fff = "E:\datachen\600009\200708-10\" & ActiveCell.Text Workbooks.Open Filename:=ff ActiveWorkbook.SaveAs Filename:=fff, FileFormat:=xlNormal ActiveWorkbook.Close ActiveCell.Offset(1, 0).Select End Sub ¼ÙexcelÎļþÑù±¾¼ûÎҵIJ©¿Í£ºhttp://chenxiaoyans.blog.sohu.com [ Last edited by nono2009 on 2009-10-9 at 22:24 ] |
» ²ÂÄãϲ»¶
Çóµ÷¼Á Óлú»¯Ñ§¿¼ÑÐ356·Ö
ÒѾÓÐ4È˻ظ´
0703 »¯Ñ§ Çóµ÷¼Á£¬Ò»Ö¾Ô¸É½¶«´óѧ 342 ·Ö
ÒѾÓÐ4È˻ظ´
086000ÉúÎïÓëÒ½Ò©µ÷¼Á
ÒѾÓÐ7È˻ظ´
305Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
348Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
332Çóµ÷¼Á
ÒѾÓÐ6È˻ظ´
¸÷λÀÏʦºÃ£¬ÎÒµÄһ־ԸΪ±±¾©¿Æ¼¼´óѧ085601²ÄÁÏר˶
ÒѾÓÐ6È˻ظ´
085600 ²ÄÁÏÓ뻯¹¤ 329·ÖÇóµ÷¼Á
ÒѾÓÐ10È˻ظ´
356Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
Ò»Ö¾Ô¸Î人Àí¹¤£¬×Ü·Ö321£¬Ó¢Ò»Êý¶þ£¬ÇóÀÏʦÊÕÁô¡£
ÒѾÓÐ7È˻ظ´
rosemary168
Òø³æ (³õÈëÎÄ̳)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 258.3
- Ìû×Ó: 15
- ÔÚÏß: 10.1Сʱ
- ³æºÅ: 527322
- ×¢²á: 2008-03-17
- ÐÔ±ð: MM
- רҵ: Óлú½ðÊô»¯Ñ§
4Â¥2009-10-08 11:58:49
jjdg
°æÖ÷ (ÖªÃû×÷¼Ò)
- ³ÌÐòÇ¿Ìû: 9
- Ó¦Öú: 223 (´óѧÉú)
- ¹ó±ö: 3.926
- ½ð±Ò: 51005.2
- ºì»¨: 238
- Ìû×Ó: 7227
- ÔÚÏß: 474.2Сʱ
- ³æºÅ: 27000
- ×¢²á: 2003-10-21
- רҵ: Ò©Îï´úлÓëÒ©ÎﶯÁ¦Ñ§
- ¹ÜϽ: ³ÌÐòÓïÑÔ
¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
nono2009(½ð±Ò+1,VIP+0):лл½»Á÷£¡»¶Ó³£À´¡£ 10-8 07:39
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
nono2009(½ð±Ò+1,VIP+0):лл½»Á÷£¡»¶Ó³£À´¡£ 10-8 07:39
|
ÄãµÄÎļþÄØ£¿ ¿´¿´ÊÇʲô¸ñʽµÄÏÈ£¡ |

2Â¥2009-10-08 00:06:09
yinguang
½ð³æ (СÓÐÃûÆø)
- Ó¦Öú: 1 (Ó×¶ùÔ°)
- ½ð±Ò: 1054.5
- É¢½ð: 5
- ºì»¨: 1
- Ìû×Ó: 247
- ÔÚÏß: 25.4Сʱ
- ³æºÅ: 649939
- ×¢²á: 2008-11-09
- ÐÔ±ð: GG
- רҵ: Ò©Îï·ÖÎö

3Â¥2009-10-08 09:13:28
chenzilong
гæ (³õÈëÎÄ̳)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 133.6
- Ìû×Ó: 18
- ÔÚÏß: 13.5Сʱ
- ³æºÅ: 538004
- ×¢²á: 2008-04-02
- רҵ: ¹«Ë¾Àí²ÆÓë²ÆÎñ¹ÜÀí
¼ÙexcelÎļþµÄ¸ñʽ
¡ï
nono2009(½ð±Ò+1,VIP+0):лл·ÖÏí¾Ñé¡£»¶Ó³£À´½»Á÷¡£ 10-9 22:24
nono2009(½ð±Ò+1,VIP+0):лл·ÖÏí¾Ñé¡£»¶Ó³£À´½»Á÷¡£ 10-9 22:24
|
¼ÙexcelÎļþµÄ¸ñʽ£¬ÎÒÒ²²»Çå³þ¡£ ²»¹ý£¬ÓÃexcel´ò¿ªºó£¬°´¡°Áí´æÎª¡±£¬ÏÔʾÎļþ¸ñʽΪ£º¡°600000.xls" ÎÊÌâ¾ÍÔÚÓÚÓÐÒýºÅ£¬¡°Áí´æÎª¡±Õý³£excelÎļþºó£¬matlab ¾Í¿É¶ÁÁË ÏÈлл¸÷λ¹Ø×¢¡£ |
5Â¥2009-10-08 16:22:44














»Ø¸´´ËÂ¥
