Cov txheej txheem:

Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel): 3 Cov Kauj Ruam
Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel): 3 Cov Kauj Ruam

Video: Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel): 3 Cov Kauj Ruam

Video: Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel): 3 Cov Kauj Ruam
Video: Saib Mis paub Poj niam (hluas nkauj) tus yam ntxwv lub siab 2024, Hlis ntuj nqeg
Anonim
Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel)
Ua Cov Phiaj Xwm Zoo Los Ntawm Cov Ntaub Ntawv Nyob Arduino (thiab Txuag Cov Ntaub Ntawv rau Excel)

Peb txhua tus nyiam ua si nrog peb P… tus lej ua haujlwm hauv Arduino IDE.

Txawm li cas los xij, thaum nws tuaj yeem muaj txiaj ntsig zoo rau cov ntawv thov yooj yim, cov ntaub ntawv raug tshem tawm vim tias muaj cov ntsiab lus ntxiv thiab nws tsis tshwj xeeb rau qhov muag. Arduino IDE tus phiaj xwm tsis khaws koj cov ntaub ntawv rau yav tom ntej saib.

Qhov no yog vim li cas hauv Phau Ntawv Qhia no Kuv tau sim kho peb cov teeb meem ib txwm muaj. Peb xav tau, tsis yog … Xav tau Arduino cov ntaub ntawv phiaj xwm uas:

-Zoo zoo

-Tsis txhob rho tawm cov ntsiab lus cov ntaub ntawv tom qab tus lej ntawm cov ntsiab lus tau kos

-Txhua tag nrho cov ntaub ntawv rau Excel yam tsis muaj tus lej zoo nkauj

Hauv cov kauj ruam tom ntej, peb yuav kawm paub yuav sau ib qho program Arduino yooj yim li cas nws tuaj yeem sib tham nrog tus kws npaj, qhia cov ntaub ntawv raug thiab khaws cia rau hauv Excel cov ntaub ntawv.

Thaum nws tsis tas yuav tsum tau saib ib qho ntawm cov vis dis aus suav nrog hauv Cov Lus Qhia no kom ua raws, nws yuav yog lub tswv yim zoo yog tias koj yog tus kawm paub pom kev yog li koj tuaj yeem ua raws. Lawv tuaj yeem pom ntawm no:

www.youtube.com/watch?v=LvNulqGuhlU&list=PL3Y_L-Yx1pgAtdG8DY_7qOHbbWfO4qomX&index=1

Kauj ruam 1: Yam Koj Yuav Tsum Tau

Yam Koj Yuav Tsum Tau
Yam Koj Yuav Tsum Tau
Yam Koj Yuav Tsum Tau
Yam Koj Yuav Tsum Tau

Rau qhov no, koj yuav xav tau ib qho Arduino lossis Arduino clone. Hauv qhov piv txwv no, Kuv tab tom siv Arduino UNO.

Koj kuj yuav tsum rub tawm cov ntawv.exe uas muaj cov phiaj xwm nyob ntawm no:

sourceforge.net/projects/arduinoexcelplotter/

Nov yog daim vis dis aus qhia yuav rub nws li cas kom nyab xeeb:

Xav paub ntau ntxiv txog yuav siv nws li cas tuaj yeem nrhiav pom hauv cov kauj ruam kawg ntawm Cov Lus Qhia no.

Kauj Ruam 2: Sau Arduino Code

Tus lej Arduino zoo ib yam li qhov koj ib txwm siv los luam rau koj li Serial monitor lossis Serial plotter hauv IDE.

Txij li cov ntawv qhia ua haujlwm ua rau qee qhov tsis txaus ntseeg tus lej, Kuv kuj tau suav nrog cov cai hauv cov ntaub ntawv nrog rau qhov txuas ntawm no rau kuv GitHub, qhov uas koj tuaj yeem rub tawm txhua cov ntaub ntawv los ntawm Cov Lus Qhia no nyob hauv ib qho.

teeb tsa tsis muaj dab tsi () {Serial.begin (9600); // Ib qho baudrate zoo} void loop () {// Tsis tau nyeem qhov sib piv qhov tseem ceeb // Tsuas yog phiaj 0-19 thiab pib dua rau (int i = 0; i <20; i ++) {Serial.println (i); // Serial.println () yog qhov xav tau los xa cov ntaub ntawv mus rau tus kws npaj ncua (500); // ncua kom tus neeg npaj lub sijhawm muaj sijhawm los npaj (tuaj yeem yog txoj kev tsawg dua 500)}}

Tshaj tawm cov cai rau koj Arduino thiab them nyiaj rau qhov chaw nres nkoj twg koj tab tom siv. Koj yuav xav tau cov ntaub ntawv no tom qab. Hauv kuv qhov xwm txheej nws yog COM11.

Kauj Ruam 3: Khiav Plotter Program

Khiav Plotter Program
Khiav Plotter Program
Khiav Plotter Program
Khiav Plotter Program

Txij li Instructables yuav tsis tso cai rau kuv upload ZIP lossis EXE cov ntaub ntawv, koj tuaj yeem tau txais ArduinoPlotter program los ntawm kuv SourceForge NTAWM NO:

sourceforge.net/projects/arduinoexcelplotter/

Vim tias qhov no tsis paub.exe cov ntaub ntawv, thaum sim khiav nws Windows yuav ceeb toom koj tias cov ntaub ntawv tuaj yeem tsis nyab xeeb, tsis quav ntsej nws thiab khiav nws lawm.

Cov lus qhia yuav siv lub plotter li cas:

-Ua ib daim ntawv Excel nyob qhov twg los sau koj cov ntaub ntawv rau. Nco ntsoov tias thawj daim ntawv npe hu ua Sheet1

-Simply khiav lub plotter.exe los ntawm ob-nias rau nws. Lub qhov rai yuav qhib.

-Type hauv baud tus nqi koj tau upload rau koj Arduino hauv IDE (hauv kuv qhov piv txwv nws yog 9600)

-Type hauv com chaw nres nkoj koj Arduino txuas nrog (tib yam li hauv Arduino IDE siv rau xa cov cai) Tsis txhob ntaus COM11, tsuas yog ntaus tus lej 11.

-Luam thiab muab tshuaj txhuam rau hauv txoj hauv kev rau koj daim ntawv Excel nrog Name.xlsx thaum kawg. Koj yuav tsum kho txoj hauv kev yog li nws siv / tsis yog ib qho xwb, piv txwv li:

C: / Users / ChemistGoneRogue / Desktop / test.xlsx - WRONG

C: / Cov neeg siv ChemistGoneRogue / Desktop / test.xlsx - TUAJ

-Yog koj tsis tau ua li ntawd ua ntej, ntsaws koj Arduino tam sim no

-Nyem rau "Save Settings" thiab kaw qhov program.

-Cov qhov rai tshiab yuav qhib uas tab tom npaj koj cov txiaj ntsig (Y axis) hauv koob (X axis) thiab khaws cia rau hauv daim ntawv teev Excel tshwj xeeb.

Thaum cov ntaub ntawv tau raug khaws tseg nrawm li koj Arduino xa nws, cov phiaj xwm tshaj tawm ib tus lej txhua 10ms.

Yog tias Koj Pom Qhov Kev Pab Cuam Zoo no, Xam Xaj Pov Ntawv Rau Nws hauv qab no (Arduino kev sib tw)

Pom zoo: