ms excel funktsiyalari

PPTX 13 pages 84.5 KB Free download

13 pages

FaylHub.uz

Download via Telegram

Size 84.5 KB

File type PPTX

Pages 13

Updated Dec 2025

Page preview (5 pages)

Scroll down 👇

1 / 13

$kiritish va chiqarish oqimlari. ma'lumotlarni ms excelga yuklash funktsiyalar. s++da funktsiyani ifodalanishi. ms excel dasturiga ma’lumotlarni export qilish uchun: quyidagi “header” fayllar yuklanadi: #include #include global o’zgaruvchilarni “variant” universal ma’lumot tipida e’lon qilamiz: variant app, books, book, sheets, sheet, cell; button1 obyektini yaratib uning ichiga: void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "salom"); } #include #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; //…………………………………………. void __fastcall tform1::button1click(tobject *sender){ vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarapp.olepropertyset("sheetsinnewworkbook",5); vvarbooks.oleprocedure("add"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); vvarsheet.olepropertyset("name", "yangilist"); vvarsheet=vvarsheets.olepropertyget("item", 3); vvarsheet.olepropertyset("name", "ikki"); //2-satr,3-ustunga salom yozuvini chiqarish "ikki“ listiga vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 2,3); vvarcell.olepropertyset("value", "salom"); } void __fastcall tform1::button1click(tobject *sender){ vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarapp.olepropertyset("sheetsinnewworkbook",5); vvarbooks.oleproced$

2 / 13

$ure("add"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); vvarsheet.olepropertyset("name", "yangilist"); vvarsheet=vvarsheets.olepropertyget("item", 3); vvarsheet.olepropertyset("name", "ikki"); for(int i=1; i #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; void __fastcall tform1::button1click(tobject *sender) { vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarapp.olepropertyget("application").olepropertyget("workbooks").oleprocedure("open","c:\\bonus\\journal.xlsx"); vvarapp.olepropertyset("visible", true); } exceldan ma’lumotlarni import qilish #include #include variant vvarapp, vvarbooks, vvarbook, vvarsheets, vvarsheet, vvarcells, vvarcell; void __fastcall tform1::button1click(tobject *sender) { vvarapp=createoleobject("excel.application"); vvarapp.olepropertyset("visible", true); vvarapp.olepropertyget("application").olepropertyget("workbooks").oleprocedure("open","c:\\bonus\\journal.xlsx"); vvarapp.olepropertyset("visible", true); vvarbooks=vvarapp.olepropertyget("workbooks"); vvarbook=vvarbooks.olepropertyget("item", 1); vvarsheets=vvarbook.olepropertyget("worksheets"); vvarsheet=vvarsheets.olepropertyget("item", 1); //vvarsheet.olepropertyset("name", "yangilist"); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 5,2); ansistring ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 6,2); ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); vvarcell=vvarsheet.olepropertyget("cells").olepropertyget("item", 7,2); ad=vvarcell.olepropertyget("value"); listbox1->items->add(ad); …………. } void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.oleproperty$

3 / 13

$get("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "id"); adotable1->first(); for (int i=0; i recordcount; i++){ cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,1); cell.olepropertyset("value", adotable1->fieldbyname("id")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,2); adotable1->next(); } } void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,1); cell.olepropertyset("value", "¹"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,2); cell.olepropertyset("value", "familiya"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,3); cell.olepropertyset("value", "ism"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,4); cell.olepropertyset("value", "tug'ilgan_sanasi"); cell=sheet.olepropertyget("cells").olepropertyget("item", 1,5); cell.olepropertyset("value", "tel"); adotable1->first(); for (int i=0; i recordcount; i++){ cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,1); cell.olepropertyset("value", adotable1->fieldbyname("¹")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,2); cell.olepropertyset("value", adotable1->fieldbyname("familiya")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,3); cell.olepropertyset("value", adotable1->fieldbyname("ism")->asvariant); cell=she$

4 / 13

et.olepropertyget("cells").olepropertyget("item", i+2,4); cell.olepropertyset("value", adotable1->fieldbyname("tug'ilgan_sanasi")->asvariant); cell=sheet.olepropertyget("cells").olepropertyget("item", i+2,5); cell.olepropertyset("value", adotable1->fieldbyname("tel")->asvariant); adotable1->next(); } } eksportning so’ngi qiymatini label ga chiqarish … adotable1->next(); } ansistring a=cell.olepropertyget("value"); label1->caption=a; } e’tiboringiz uchun rahmat /docprops/thumbnail.jpeg ‘mapaywottapa ms excelra wna

5 / 13

Want to read more?

Download all 13 pages for free via Telegram.

Download full file

About "ms excel funktsiyalari"

kiritish va chiqarish oqimlari. ma'lumotlarni ms excelga yuklash funktsiyalar. s++da funktsiyani ifodalanishi. ms excel dasturiga ma’lumotlarni export qilish uchun: quyidagi “header” fayllar yuklanadi: #include #include global o’zgaruvchilarni “variant” universal ma’lumot tipida e’lon qilamiz: variant app, books, book, sheets, sheet, cell; button1 obyektini yaratib uning ichiga: void __fastcall tform1::button19click(tobject *sender) { app=createoleobject("excel.application"); app.olepropertyset("visible", true); app.olepropertyset("sheetsinnewworkbook",5); books=app.olepropertyget("workbooks"); books.oleprocedure("add"); book=books.olepropertyget("item", 1); sheets=book.olepropertyget("worksheets"); sheet=sheets.olepropertyget("item", 1); sheet.olepropertyset("name", "yangilist"); cell=she...

This file contains 13 pages in PPTX format (84.5 KB). To download "ms excel funktsiyalari", click the Telegram button on the left.

Tags: ms excel funktsiyalari PPTX 13 pages Free download Telegram

ms excel funktsiyalari

Page preview (5 pages)

Want to read more?

About "ms excel funktsiyalari"

Similar files