有偿找人帮设计个MATLAB程序 目标是建立数据库 让我excel中的产品可以按规格在数据库中自动搜索出相应报价

有偿!急求! 加QQ:670324210 注明matlab代做 详谈!
2025-05-15 02:21:57
推荐回答(1个)
回答1:

matlab的帮助里面有例子:

Example -- Importing Data From an Excel Application

Assume that you have an Excel spreadsheet stocks.xls. This spreadsheet contains the prices of three stocks in row 3 (columns 1 through 3) and the number of shares of these stocks in rows 6 through 8 (column 2). Initiate conversation with Excel with the command
channel = ddeinit('excel','stocks.xls')

DDE functions require the rxcy reference style for Excel worksheets. In Excel terminology the prices are in r3c1:r3c3 and the shares in r6c2:r8c2.
Request the prices from Excel:

prices = ddereq(channel,'r3c1:r3c3')

prices =
42.50 15.00 78.88

Next, request the number of shares of each stock:
shares = ddereq(channel, 'r6c2:r8c2')

shares =
100.00
500.00
300.00