|
||||||
|
Recently, I got a tough task about collecting external sources link back to my site. It may be a piece cake to most of the people, but what I’ve got is a list of URL and an excel. Remove common http pattern As URLs are beginning with http://, so I removed this part by a [...] 平時用 MS Access 就用得多, 其中有一個叫 format 既 function 可以將資料用規定特定既格式輸出. 但係有日係 Excel 就唔識用, 仲搞咗好耐. 最後當然俾我搞掂, 就係用 Text() , 例如 =Text(7,”00″) 輸出結果為 07 下次有機會再同各位研究一下. To insert an Excel worksheet Position the cursor at the point where you want to place the worksheet From the Insert menu, click Object Select the Create from file option, and then click Browse Navigate to the folder that contains the worksheet you want to insert In the list of file and folder names, click [...] 先在 File –> Page Setup. 在 Sheet tab 內將 Comments 設定為 “As displayed on sheet”. 之後在 Tools –> Options 內進入 View tab, 選取 “Comment and Indicator” 便可以 printout 內直接列印附註. |
|
|||||
|
Copyright © 2012 小棗棧 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
