Kod:
using System;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
namespace StokKoduUretici
{
public partial class Form1 : Form
{
Excel.Application excelApp;
Excel.Workbook workbook;
Excel.Worksheet worksheet;
int StokKoduIndex = 1;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
excelApp = new Excel.Application();
excelApp.Visible = true;
workbook = excelApp.Workbooks.Add();
worksheet = (Excel.Worksheet)workbook.ActiveSheet;
worksheet.Cells[1, 1] = "STK01"; // Başlangıç değerini alır.
}
private void BtnStokKoduUret_Click(object sender, EventArgs e)
{
StokKoduIndex++;
string YeniStokKodu = "STK" + StokKoduIndex.ToString("00");
worksheet.Cells[StokKoduIndex, 1] = YeniStokKodu;
TxtSonStokKodu.Text = YeniStokKodu;
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
workbook.SaveAs("C:\\Your\\Excel\\File\\Path.xlsx"); // Excel dosyasını kaydedeceğiniz yolu gösterir.
workbook.Close();
excelApp.Quit();
}
}
}