TW508508B - Method for generating spreadsheet files in website - Google Patents
Method for generating spreadsheet files in website Download PDFInfo
- Publication number
- TW508508B TW508508B TW90117990A TW90117990A TW508508B TW 508508 B TW508508 B TW 508508B TW 90117990 A TW90117990 A TW 90117990A TW 90117990 A TW90117990 A TW 90117990A TW 508508 B TW508508 B TW 508508B
- Authority
- TW
- Taiwan
- Prior art keywords
- website
- file
- client
- generating
- trial balance
- Prior art date
Links
Landscapes
- Information Transfer Between Computers (AREA)
Abstract
Description
508508 五、發明說明α) 【發明領域】 本發明係為一種產生試算表檔案的方法,特別是一種 在網站中產生試算表檔案的方法。 【發明背景】 目前,當用戶端連結一個提供瀏覽表格功能的網站 時,用戶端便可以在網站上瀏覽到此表格,但是當用戶端 所瀏覽的表格過大,,無法顯示於網站中的同一網頁時,用 戶端便無法於同一網頁瀏覽到此表格,此外,用戶端在下 載此網頁時,亦無法一次就完整的下載此表格,而其尚有 其他的缺點: 1. 當用戶端列印時,只能獲取當前所列印之網頁的内 容,所以往往會發生於目前頁面能見到表格的表頭,但卻 於後一頁看不到表頭的情形,也就是表格並無法完整的列 印於同一頁面。 2. 當用戶端欲將網頁中的表格保存成以超文字標記語 言(Hypertext Markup Language )儲存的檔案時,貝1J 會 因為表格中的内容是儲存於網站中,因此用戶端所儲存的 檔案並非一個完整的檔案。 基於上述原因,本發明提供一種在網站中產生試算表 檔案的方法,以將在此網站中以表格所顯示之内容,能夠 以試算表的型式完整的顯示於網站中的同一網頁,以供用 戶端瀏覽,並且供用戶端編輯此試算表,甚至是將此試算 表完整的列印出來。 【發明之目的及概述】508508 V. Description of the invention α) [Field of invention] The present invention is a method for generating trial balance files, especially a method for generating trial balance files in a website. [Background of the Invention] At present, when a client connects to a website that provides a form browsing function, the client can browse the form on the website, but when the form browsed by the client is too large, it cannot be displayed on the same page on the website At this time, the client cannot browse to this form on the same webpage. In addition, when the client downloads this webpage, it cannot download the form in one go. There are other disadvantages: 1. When the client prints , Can only get the content of the currently listed webpage, so it often happens that the header of the form can be seen on the current page, but the header is not visible on the next page, that is, the form cannot be printed completely On the same page. 2. When the client wants to save the form in the webpage as a file stored in Hypertext Markup Language, Bay 1J will store the content in the form on the website, so the file saved by the client is not A complete archive. Based on the above reasons, the present invention provides a method for generating a trial balance file in a website, so that the content displayed in the form on this website can be displayed in the form of a trial balance on the same page of the website for users. Browser, and for the client to edit the spreadsheet, or even print it out completely. [Objective and summary of the invention]
m ft κίλΐ ivm ft κίλΐ iv
第4頁 508508 五、發明說明(2) 本發明的主要目的即為提供一種在網站中產生試算表 檔案的方法,以將所產生之試算表顯示於網站中的同一網 頁,並供一次完整的下載或列印出此試算表檔案。 根據本發明所揭露的在網站中產生試鼻表樓案的方 法,係包括有下列步驟:首先,當一用戶端連結一提供產 生試算表檔案功能的網站時,藉由此用戶端設定一試算表 檔案之表頭,此表頭中可包含有編號、英文姓名、身份證 字號、卡號、分公司及名稱電話,或是此用戶端所需之其 他種的表頭,之後,再透過此用戶端傳輸一產生此試算表 檔案的訊息予此網站,此訊息中包括有前一步驟所設定此 試算表檔案之表頭的資料,接著,當此網站接收此產生訊 息,便依照此產生訊息,產生試算表檔案,並儲存於此網 站之一資料庫中;最後,結束此方法之流程;因而本發明 可供用戶端於網站中的同一網頁中瀏覽此試算表檔案,並 提供一次完整的下載或列印。 為使對本發明的目的、構造特徵及其功能有進一步的 了解,茲配合圖示詳細說明如下: 【實施例詳細說明】 本發明係應用於一網站中,以供一用戶端透過網際網 路的作業環境,於此網站中產生一試算表檔案,並供用戶 端由此網站下載一個完整的試算表檔案,用戶端更可編輯 或列印此試算表檔案,以及供用戶端於此網站中,得以瀏 覽到一個完整的試算表檔案,而非僅僅只是此試算表檔案 中的一部份。Page 4 508508 V. Description of the invention (2) The main purpose of the present invention is to provide a method for generating a trial balance file in a website, so that the generated trial balance is displayed on the same page of the website, and is provided for a complete Download or print this spreadsheet file. According to the method for generating a nose test table in a website disclosed in the present invention, the method includes the following steps: First, when a client connects to a website providing a function of generating a spreadsheet file, a trial is set by the client The header of the table file. This header can contain the number, English name, ID number, card number, branch and name phone, or other types of headers required by this client, and then through this user The terminal transmits a message that generates the spreadsheet file to this website. This message includes the data of the header of the spreadsheet file that was set in the previous step. Then, when the website receives the generated message, it generates the message according to this. Generate a spreadsheet file and store it in a database on this website; finally, end the process of this method; therefore, the invention can allow the client to browse this spreadsheet file on the same page on the website and provide a complete download Or print. In order to further understand the purpose, structural features, and functions of the present invention, the following detailed description is given in conjunction with the drawings: [Detailed description of the embodiment] The present invention is applied to a website for a client to pass through the Internet. Operating environment, a spreadsheet file is generated on this website, and the client can download a complete spreadsheet file from this website. The client can edit or print this spreadsheet file, and it can be used by the client on this website. Have access to a complete spreadsheet file, not just a portion of it.
第5頁 508508 五、發明說明(3) 而如「第1圖」中所示,根據本發明所揭露的在網站 中產生試算表檔案的方法之流程圖,係包括有下列步驟: 首先,開始此方法的流程(步驟1 0 ); 藉由一用戶端連結一提供產生試算表檔案功能的網站 (步驟11 ); 再藉由此用戶端設定一試算表檔案之表頭(步驟1 2 ),表頭中可包含有編號、英文姓名、身份證字號、卡 號、分公司及名稱電話,或是此用戶端所需之其他種的表 頭; 並藉由此用戶端傳輸一產生此試算表檐案的訊息予網 站(步驟1 3 ),也就是此訊息中包括有步驟1 2所設定試算 表檔案之表頭的資料; 然後,藉由網站接收此產生訊息(步驟1 4 ); 接著,依此產生訊息,藉由網站產生此試算表檔案, 並儲存於此網站之一資料庫中(步驟1 5 ); 最後,結束此方法之流程(步驟1 6 )。 如「第2圖」中所示,上述再藉由此用戶端設定一試 算表檔案之表頭的步驟中,更包括有下列步驟:首先,開 始流程(步驟2 1 ):然後設定此試算表檔案之表頭的一攔 位内容(步驟2 2 ),而一攔位内容也就是輸入於試算表中 一欄位的如:編號、英文姓名、身份證字號、卡號、分公 司或名稱電話等内容之一個;再確認完成設定此試算表檔 案之表頭(步驟2 3 ),若已完成時,則結束此流程(步驟 24 ),若未完成時,則回到步驟22,並繼續進行後續之流Page 5 508508 5. Description of the invention (3) As shown in "Figure 1", the flow chart of the method for generating a spreadsheet file in a website according to the present disclosure includes the following steps: First, start The flow of this method (step 10); a client terminal is connected to a website that provides the function of generating a spreadsheet file (step 11); and then a header of a spreadsheet file is set by the client terminal (step 12), The header can include the number, English name, ID number, card number, branch company and name phone, or other types of header required by this client; and the trial table can be generated by transmitting from this client. The message to the website (step 13), that is, the message includes the data of the header of the spreadsheet file set in step 12; then, receive the generated message through the website (step 14); then, follow the steps With this generated message, the spreadsheet file is generated by the website and stored in a database of this website (step 15). Finally, the process of this method is ended (step 16). As shown in "Figure 2", the above steps of setting a header of a spreadsheet file by the client further include the following steps: First, start the process (step 21): and then set up this spreadsheet A block content in the header of the file (step 22), and a block content is also entered in a field in the trial calculation form such as: number, English name, ID number, card number, branch or name phone, etc. One of the contents; then confirm the completion of setting the header of this trial balance file (step 2 3), if it is completed, end this process (step 24); if it is not completed, return to step 22 and continue to follow up Stream
508508 五、發明說明(4) 程。 另外,步驟1 3之前更包括此用戶端輸入產生此試算表 檔案之訊息的步驟。 因而本發明可以供用戶端於網站中產生試算表檔案, 並於此網站的同一網頁中瀏覽,及一次完整的下載或列 印〇 當然,當此用戶端將此試算表檔案儲存成一範本式檔 案時,如「第3圖」所示,本發明更可接續上述之步驟 1 5,而包括有下列步驟:首先,開始此流程(步驟1 5 0 ),此用戶端再次連結此網站(步驟1 5 1 ),此用戶端自 網站下載此試算表檔案(步驟1 5 2 ),此用戶端以超文字 標記語言(H y p e r t e X t M a r k ϋ p L a n g u a g e )編輯此試算表 檔案(步驟1 5 3 ),此用戶端將經編輯之試算表檔案以文 件式檔案儲存成另一試算表檔案於資料庫中(步驟154 ),最後,結束此流程(步驟1 5 5 )。 當然,當此用戶端將此試算表檔案儲存成一文件式檔 案時,如「第4圖」所示,本發明更可接續上述之步驟 1 5,而包括有下列步驟:首先,開始此流程(步驟1 5 0 1 ),此用戶端再次連結此網站(步驟1 5 11 ),此用戶端自 此網站下載此試算表檔案(步驟1 5 2 1 ),此用戶端以超文 字標記語言(Hypertext Markup Language)編輯此試算 表檔案(步驟1 5 3 1 ),此用戶端將此經編輯之試算表檔案 儲存於資料庫中以更新此試算表檔案(步驟1 54 1 ),最 後,結束此流程(步驟1 5 5 1 )。508508 V. Description of Invention (4) Process. In addition, steps 1 to 3 include the step of the client inputting the information to generate the spreadsheet file. Therefore, the present invention can be used by a client to generate a spreadsheet file on a website, browse it on the same page of this website, and download or print it once. Of course, when the client saves this spreadsheet file as a template file At this time, as shown in "Figure 3", the present invention can continue to the above-mentioned step 15, and includes the following steps: First, start the process (step 1 50), the client connects to the website again (step 1) 5 1), the client downloads the spreadsheet file from the website (step 1 5 2), and the client edits the spreadsheet file in Hypertext Markup Language (Hyperte X t Mark L p Language) (step 1 5 3) The client saves the edited spreadsheet file as a document file into another spreadsheet file in the database (step 154). Finally, the process ends (step 1 5 5). Of course, when the client saves the spreadsheet file as a document file, as shown in "Figure 4", the present invention can continue to the above steps 15, and includes the following steps: First, start this process ( Step 1 5 0 1), the client connects to the website again (step 1 5 11), the client downloads the spreadsheet file from the website (step 1 5 2 1), and the client uses Hypertext Markup Language (Hypertext Markup Language) edit the spreadsheet file (step 1 5 3 1), the client stores the edited spreadsheet file in the database to update the spreadsheet file (step 1 54 1), and finally, end the process (Step 1 5 5 1).
第7頁 508508 五、發明說明(5) 又、如「第5圖」中所示,根據本發明所揭露的在網 站中產生試算表檔案的方法之另一流程圖,係包括有下列 步驟: 首先,開始此方法的流程(步驟1 0 ); 藉由一用戶端連結一提供產生試算表檔案功能的網站 (步驟11 ); 再藉由此用戶端設定一試算表檔案之表頭(步驟1 2 ),表頭中可包含有編號、英文姓名、身份證字號、卡 號、分公司及名稱電話,或是此用戶端所需之其他種的表 頭; Μ 並藉由此用戶端傳輸一產生此試算表檔案的訊息予網 站(步驟1 3 ),也就是此訊息中包括有步驟1 2所設定試算 表檔案之表頭的資料; 然後,藉由網站接收此產生訊息(步驟1 4 ); 接著,依此產生訊息,藉由網站產生此試算表檔案, 並儲存於此網站之一資料庫中(步驟1 5 ); 再藉由網站傳輸此試算表檔案予用戶端(步驟1 7 ); 透過此用戶端以超文字標記語言編輯此試算表檔案 (步驟1 8 ); 藉由此用戶端傳輸此經編輯之試算表檔案予此網站 丨瞻 (步驟1 9 ); 透過此網站依此經編輯之試算表檔案更新儲存於資料 庫中之此試算表檔案(步驟2 0 ); 最後,結束此方法之流程(步驟1 6 )。Page 7 508508 5. Description of the invention (5) Another, as shown in "Figure 5", another flowchart of the method for generating a spreadsheet file on a website according to the present invention, includes the following steps: First, start the flow of this method (step 10); connect a client to a website that provides the function of generating spreadsheet files (step 11); and then set the header of a spreadsheet file from this client (step 1) 2), the header can include the number, English name, ID number, card number, branch company and name phone, or other types of header required by this client; Μ and generated by this client transmission The message of the spreadsheet file is sent to the website (step 13), that is, the message includes the data of the header of the spreadsheet file set in step 12; then, the generated message is received by the website (step 14); Then, a message is generated according to this, the spreadsheet file is generated by the website, and stored in a database on this website (step 15); and then the spreadsheet file is transmitted to the client through the website (step 17); Through this client Edit the spreadsheet file in Hypertext Markup Language (step 18); transmit the edited spreadsheet file to this website through this client (step 19); follow this edited spreadsheet file through this website Update the trial balance file stored in the database (step 20). Finally, end the process of this method (step 16).
508508 五、發明說明(6) 如「第2圖」中所示,上述再藉由此用戶端設定一試 算表檔案之表頭的步驟中,更包括有下列步驟:首先,開 始流程(步驟2 1 );然後設定此試算表檔案之表頭的一攔 位内容(步驟2 2 ),而一欄位内容也就是輸入於試算表中 一欄位的如:編號、英文姓名、身份證字號、卡號、分公 司或名稱電話等内容之一個;再確認完成設定此試算表檔 案之表頭(步驟2 3 ),若已完成時,則結束此流程(步驟 2 4),若未完成時,則回到步驟2 2,並繼續進行後續之流 程。 另外,步驟13之前更包括此用戶端輸入產生此試算表 檔案之訊息的步驟。 因而本發明可以供用戶端於網站中產生試算表檔案, 並於編輯此檔案後,重新回傳此檔案至網站,以更新網站 中所儲存之此檔案的資料,並且可供用戶端於網站中的同 一網頁瀏覽,及一次完整的下載或列印。 【達成之功效】 本發明係為一種在網站中產生試算表檔案的方法,其 可供用戶端於網站中的同一網頁,瀏覽先前所產生之試算 表,並供用戶端一次完整的下載或列印出此試算表檔案。 以上所述者,僅為本發明其中的較佳實施例而已,並彳i 非用來限定本發明的實施範圍;即凡依本發明申請專利範 圍所作的均等變化與修飾,皆為本發明專利範圍所涵蓋。508508 V. Description of the invention (6) As shown in "Figure 2", the above steps of setting the header of a spreadsheet file by the client further include the following steps: First, start the process (step 2 1); Then set a block content of the header of this spreadsheet file (step 2 2), and the content of a field is also entered in a field in the spreadsheet such as: number, English name, ID number, One of the contents such as card number, branch or name and telephone; then confirm that the header of this trial balance file is set (step 2 3). If it is completed, then this process is ended (step 2 4). If it is not completed, then Return to step 2 2 and continue with the subsequent process. In addition, step 13 includes the step of the client inputting a message for generating the spreadsheet file. Therefore, the present invention can be used by a client to generate a spreadsheet file in a website, and after editing the file, re-transmit the file to the website to update the data of the file stored in the website, and it can be used by the client in the website. The same web page, and a full download or print. [Achieved effect] The present invention is a method for generating a trial balance file in a website, which can be used by a client to browse a previously generated trial balance on the same webpage in the website, and provided for the client to download or list a complete one time. Print this spreadsheet file. The above are only the preferred embodiments of the present invention, and are not intended to limit the scope of implementation of the present invention; that is, all equal changes and modifications made in accordance with the scope of the patent application for the present invention are patents of the present invention Covered.
第9頁 508508 圖式簡單說明 第1圖為本發明之流程圖。 第2圖為第1圖中之藉由此用戶端設定一試算表檔案之表頭 的步驟的流程圖。 第3圖為第1圖中之依此產生訊息,藉由網站產生此試算表 檔案,並儲存於此網站之一資料庫中的步驟的流程圖。 第4圖為第1圖中之依此產生訊息,藉由網站產生此試算表 檔案,並儲存於此網站之一資料庫中的步驟的另一流程 圖。 第5圖為本發明之另一流程圖。Page 9 508508 Brief Description of Drawings Figure 1 is a flowchart of the present invention. Fig. 2 is a flowchart of the steps in Fig. 1 for setting the header of a spreadsheet file by the client. Figure 3 is a flowchart of the steps in Figure 1 to generate the message accordingly, generate the spreadsheet file from the website, and store it in a database on this website. Figure 4 is another flow chart of the steps in Figure 1 to generate the message accordingly, generate the spreadsheet file from the website, and store it in a database on this website. FIG. 5 is another flowchart of the present invention.
第10頁Page 10
Claims (1)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW90117990A TW508508B (en) | 2001-07-24 | 2001-07-24 | Method for generating spreadsheet files in website |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW90117990A TW508508B (en) | 2001-07-24 | 2001-07-24 | Method for generating spreadsheet files in website |
Publications (1)
Publication Number | Publication Date |
---|---|
TW508508B true TW508508B (en) | 2002-11-01 |
Family
ID=27657027
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW90117990A TW508508B (en) | 2001-07-24 | 2001-07-24 | Method for generating spreadsheet files in website |
Country Status (1)
Country | Link |
---|---|
TW (1) | TW508508B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8234293B2 (en) | 2005-09-08 | 2012-07-31 | Microsoft Corporation | Autocompleting with queries to a database |
-
2001
- 2001-07-24 TW TW90117990A patent/TW508508B/en not_active IP Right Cessation
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8234293B2 (en) | 2005-09-08 | 2012-07-31 | Microsoft Corporation | Autocompleting with queries to a database |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7024415B1 (en) | File conversion | |
TWI227976B (en) | Real-time search engine | |
US7406498B2 (en) | Dynamic integration of web sites | |
CA2250853C (en) | Processing messages which include an address to further information | |
US6161124A (en) | Method and system for preparing and registering homepages, interactive input apparatus for multimedia information, and recording medium including interactive input programs of the multimedia information | |
US6078921A (en) | Method and apparatus for providing a self-service file | |
US6466968B2 (en) | Information processing system capable of file transmission and information processing apparatus in the system | |
US20170063984A1 (en) | System, Method and Apparatus for Media Submission | |
Nebel et al. | Form-based file upload in HTML | |
US20020046235A1 (en) | Document creation and delivery | |
US7634719B2 (en) | Print system and information processing apparatus | |
US20040172484A1 (en) | Device-specific communicating between a transmitting device and a receving device | |
DE10236188A1 (en) | Web-based imaging service that converts web pages into content on behalf of another website | |
MXPA04011432A (en) | Application generator. | |
EP1486874A1 (en) | Document file read system using network | |
JP2008097613A (en) | Method and apparatus for providing third-party service | |
WO2007052353A1 (en) | System and method for data transmission | |
JP2006252001A (en) | Document processor | |
US20030093756A1 (en) | Extensible mark-up language (XML) tracer for conversion of XML documents to hypertext markup language (HTML) | |
TW508508B (en) | Method for generating spreadsheet files in website | |
TW200408964A (en) | Method for transfer of network data | |
US20070291302A1 (en) | Method and System for Printing From Web Applications, a Corresponding Computer Program and a Corresponding Computer-Readable Storage Means | |
US20070028236A1 (en) | File transfer system | |
US7363579B2 (en) | Mark-up of automated documents | |
Nebel et al. | RFC1867: Form-based file upload in HTML |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
GD4A | Issue of patent certificate for granted invention patent | ||
MM4A | Annulment or lapse of patent due to non-payment of fees |