ODS zuwa Excel

Maida ODS zuwa Excel (XLS, XLSX) ta amfani da C# .NET

ODS da Excel shahararrun nau’ikan fayil ne da ake amfani da su don adanawa da sarrafa bayanan falle. Duk da yake duka tsarin suna ba da fasali iri ɗaya, ba koyaushe suke dacewa da juna ba. Wannan na iya haifar da matsaloli lokacin rabawa ko haɗin gwiwa akan bayanan maƙunsar bayanai tare da wasu waɗanda ƙila ba su da damar yin amfani da fayilolin ODS. A irin waɗannan lokuta, canza fayilolin ODS zuwa tsarin Excel na iya zama dole. Mayar da ODS zuwa tsarin Excel kuma yana sauƙaƙa yin aiki tare da bayanai a cikin Microsoft Excel, waɗanda ake amfani da su sosai a cikin kasuwanci da ƙungiyoyi. A cikin wannan labarin, za mu bincika yadda ake canza ODS zuwa Excel ta amfani da C# REST API kuma mu samar da cikakkiyar jagora don taimaka muku samun nasarar canza fayilolinku.

API ɗin Canjin ODS zuwa Excel

Aspose.Cells Cloud SDK for .NET API ne mai ƙarfi, yana ba da fasali iri-iri waɗanda ke sauƙaƙa sauya fayiloli yayin tabbatar da inganci da daidaiton fitarwa. SDK yana ba da kewayon zaɓuɓɓukan juyawa, gami da jujjuya ODS zuwa XLS, ODS zuwa XLSX, da sauran tsarin Excel. Hakanan zaka iya ƙididdige kewayon sel da za a canza kuma yi amfani da zaɓuɓɓukan tsarawa zuwa fitarwa. Saboda haka, babban kayan aiki ne ga duk wanda ke neman sauya fayilolin ODS zuwa tsarin Excel cikin sauri da sauƙi.

Don haka don farawa, da fatan za a bincika Aspose.Cells-Cloud a cikin mai sarrafa fakitin NuGet kuma danna maɓallin Ƙara Kunshin. Na biyu, idan baku da asusu akan Cloud Dashboard, da fatan za a ƙirƙiri asusun kyauta ta amfani da ingantaccen adireshin imel kuma sami keɓaɓɓen takaddun shaidarku.

Canjin ODS zuwa Excel ta amfani da C#

Domin yin canjin ODS zuwa Excel, za mu yi amfani da GetWorkbook API. Da fatan za a duba snippet code mai zuwa.

// Don cikakkun misalai da fayilolin bayanai, da fatan za a je zuwa 
https://github.com/aspose-cells-cloud/aspose-cells-cloud-dotnet/

// Samu bayanan abokin ciniki daga https://dashboard.aspose.cloud/
string clientSecret = "4d84d5f6584160cbd91dba1fe145db14";
string clientID = "bb959721-5780-4be6-be35-ff5c3a6aa4a2";
        
// ƙirƙiri misalin CellsApi yayin wuce ClientID da ClientSecret
CellsApi cellsInstance = new CellsApi(clientID, clientSecret);

// Sunan shigar da fayil ODS
string input_ODS = "input.ods";
// Sunan sakamakon littafin aikin Excel
string resultant_File = "resultant.xlsx";

try
{
    // karanta abun cikin fayil ɗin ODS zuwa misalin Fayil
    var file = System.IO.File.OpenRead(input_ODS);

    // fara aikin juyawa
    var response = cellsInstance.CellsWorkbookPutConvertWorkbook(file, format:"XLSX", outPath:resultant_File);

    // buga saƙon nasara idan haɗin kai ya yi nasara
    if (response != null && response.Equals("OK"))
    {
        Console.WriteLine("ODS to Excel converted successfully !");
        Console.ReadKey();
    }
}
catch (Exception ex)
{
    Console.WriteLine("error:" + ex.Message + "\n" + ex.StackTrace);
}
ODS zuwa Excel

ODS zuwa samfotin juyawa na Excel.

Bari mu fahimci snippet code:

CellsApi cellsInstance = new CellsApi(clientID, clientSecret);

Ƙirƙiri wani abu na CellsApi yayin ƙaddamar da bayanan abokin ciniki azaman muhawara.

var file = System.IO.File.OpenRead(input_ODS);

Karanta abun ciki na shigar da ODS zuwa abu FileStream.

var response = cellsInstance.CellsWorkbookPutConvertWorkbook(file, format:"XLSX", outPath:resultant_File);

Yanzu don canza ODS zuwa Excel, kira wannan API. An bayar da tsarin fitarwa da sunan fayil ɗin sakamakon azaman mahawara ga wannan hanyar. Bayan juyawa, an adana sakamakon XLSX zuwa ajiyar girgije.

Domin gwada yanayin juyawa, kuna iya yin la’akari da zazzage fayil ɗin shigarwar input.ods. Don bayanin ku, sakamakon Excel da aka samar a sama misali ana loda shi akan resultant.xlsx.

ODS zuwa XLS ta amfani da Umarnin CURL

Aspose.Cells Cloud Hakanan ana iya amfani dashi tare da umarnin cURL don canza fayilolin ODS zuwa tsarin Excel. cURL sanannen kayan aikin layin umarni ne da ake amfani dashi don canja wurin bayanai akan ka’idoji daban-daban, gami da HTTP, FTP, da sauransu. Yin amfani da umarnin CURL, zaku iya sauya fayilolin ODS ɗinku cikin sauƙi zuwa tsarin Excel ba tare da buƙatar kowane ilimin shirye-shirye ba.

Don farawa, kuna buƙatar shigar da cURL akan tsarin ku da asusun Aspose.Cells Cloud tare da maɓallin API. Yanzu samar da accessToken dangane da bayanan abokin ciniki:

curl -v "https://api.aspose.cloud/connect/token" \
-X POST \
-d "grant_type=client_credentials&client_id=bb959721-5780-4be6-be35-ff5c3a6aa4a2&client_secret=4d84d5f6584160cbd91dba1fe145db14" \
-H "Content-Type: application/x-www-form-urlencoded" \
-H "Accept: application/json"

Da zarar kun sami damarToken, zaku iya amfani da umarnin cURL mai zuwa don loda fayil ɗin ODS ɗin ku zuwa ma’ajiyar gajimare:

curl -v "https://api.aspose.cloud/v3.0/cells/storage/file/{filePath}" \
-X PUT \
-F file=@{localFilePath} \
-H "Content-Type: multipart/form-data" \
-H "Authorization: Bearer {accessToken}"

Sauya {filePath} tare da hanyar da kake son adana fayil ɗin a cikin ma’ajiyar gajimare, `{localFilePath}’ tare da hanyar fayil ɗin ODS akan tsarin gida, da ‘‘accessToken}’ tare da damar Aspose Cloud. alama.

Da zarar kun loda fayil ɗin zuwa ma’ajiyar gajimare, kuna buƙatar amfani da umarnin cURL mai zuwa don canza fayil ɗin ODS zuwa tsarin Excel:

curl -v "https://api.aspose.cloud/v3.0/cells/{name}?format=XLSX&isAutoFit=true&onlySaveTable=false&outPath=resultant.xlsx&checkExcelRestriction=true" \
-X GET \
-H "accept: application/json" \
-H "authorization: Bearer {accessToken}"

Sauya {name} tare da sunan fayil ɗin ODS da kuka ɗora zuwa ma’ajiyar gajimare, da ‘‘accessToken}’ tare da alamar samun dama da aka samar a sama. Hakanan zaka iya ƙayyade tsarin Excel da ake so (misali, XLS, XLSX) a cikin ma’aunin ’tsara’. Bayan juyawa, sakamakon Excel za a adana shi a cikin ajiyar girgije iri ɗaya.

Karshen Magana

A cikin wannan labarin, mun bincika hanyoyi daban-daban don canza fayilolin ODS zuwa tsarin Excel ta amfani da umarnin C# .NET da cURL. Mun tattauna buƙatar ODS zuwa fassarar Excel da kuma yadda zai iya taimakawa wajen haɗin gwiwa da raba bayanan maƙunsar bayanai. Mun kuma duba abubuwan da Aspose.Cells Cloud SDK ke bayarwa don NET da kuma yadda za a iya amfani da shi don canza fayilolin ODS zuwa nau’ikan Excel iri-iri. Bugu da ƙari, mun koyi yadda ake amfani da umarnin cURL tare da Aspose.Cells Cloud don canza fayilolin ODS zuwa tsarin Excel daga layin umarni. Waɗannan hanyoyin suna ba da sassauci da dacewa ga duk wanda ke neman canza fayilolin ODS zuwa tsarin Excel, ko sun saba da shirye-shirye ko sun fi son ƙirar layin umarni.

Hanyoyin haɗi masu amfani

Abubuwan da aka Shawarar

Da fatan za a ziyarci hanyoyin haɗin yanar gizon don ƙarin koyo game da: