CARA EXPORT FILE PDF KE EXCEL

In this day and age, digital documents have become the norm for sharing and storing information. One of the most popular formats for these documents is PDF, which is widely used for various purposes such as reports, contracts, and presentations.

Exporting Excel Files to PDF

Excel files are commonly used for data analysis and presentations, and sometimes it is necessary to convert them to PDF for easier sharing and printing. Here are some steps to export Excel files to PDF:

  1. Open the Excel file that you want to convert to PDF.
  2. Click on “File” in the menu bar and then click “Export”.
  3. Choose “Create PDF/XPS” and then click on “Create PDF/XPS”.
  4. Choose the location where you want to save the PDF file and then click “Publish”.

That’s it! Your Excel file is now saved in PDF format. This method is applicable for Excel 2010 and later versions.

Exporting CodeIgniter Database to Excel and PDF

CodeIgniter is a powerful PHP framework that is widely used for web development. Exporting the CodeIgniter database to Excel and PDF can be useful for analyzing and presenting data. Here’s how to do it:

  1. Create a helper file named “download_helper.php” in the “application/helpers” directory.
  2. In the “download_helper.php” file, define the following two functions:


    function export_excel($filename, $data)
    header("Content-type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=".$filename.".xls");
    header("Pragma: no-cache");
    header("Expires: 0");
    echo $data;

    function export_pdf($filename, $data)
    require('fpdf.php');

    class PDF extends FPDF
    function BasicTable($header, $data)
    //Table header
    foreach($header as $col)
    $this->Cell(40,7,$col,1);

    $this->Ln();
    //Table data
    foreach($data as $row)
    foreach($row as $col)
    $this->Cell(40,6,$col,1);

    $this->Ln();

    $pdf = new PDF();
    $pdf->AddPage();
    $pdf->SetFont('Arial','B',16);
    $pdf->Cell(40,10,$filename);
    $pdf->Ln();
    $pdf->BasicTable(array('Column 1','Column 2','Column 3'), $data);
    $pdf->Output();

  3. In the controller, load the “download_helper” and call the functions to export the database to Excel or PDF.


    public function export()
    $this->load->model('ModelName');
    $data = $this->ModelName->getData(); // Replace ModelName and getData with your own model and function name

    $filename = "Database";

    // Export to Excel
    $excel = "

    ";
    foreach($data as $row)
    $excel .= "

    ";

    $excel .= "

    Column 1 Column 2 Column 3
    ".$row['column1']." ".$row['column2']." ".$row['column3']."

    ";

    $this->load->helper('download');
    export_excel($filename, $excel);

    // Export to PDF
    $pdf = array();
    foreach($data as $row)
    $pdf[] = array($row['column1'],$row['column2'],$row['column3']);

    $this->load->helper('download');
    export_pdf($filename, $pdf);

  4. Create a link or button in the view file to call the controller function.
Baca Juga :  cara membuat master otomatis data disertai gambar dengan excel Tutorial membuat aplikasi "peminjaman buku" berbasil visual basic 6

Exporting PowerPoint Files to Video

Creating a video from a PowerPoint presentation can be useful for sharing the content on video platforms or for presentations that cannot be done in person. Here are two methods for exporting PowerPoint files to video:

Using PowerPoint

  1. Open the PowerPoint presentation that you want to export to video.
  2. Click on “File” in the menu bar and then click “Export”.
  3. Choose “Create a Video” and then select the video quality and size.
  4. Click “Create Video” and choose the location where you want to save the video file.

Using Third-Party Software

There are several third-party software that can convert PowerPoint files to video, such as Camtasia, Adobe Presenter, and iSpring Suite. Here is an example of how to export PowerPoint files to video using Camtasia:

  1. Open Camtasia and choose “New Project”.
  2. Click on “Import Media” and select the PowerPoint presentation that you want to export to video.
  3. Drag the presentation file to the timeline.
  4. Click on “Produce and Share” and then choose the video format and settings.
  5. Click “Produce” and choose the location where you want to save the video file.

FAQ

How do I convert PDF files to Excel?

There are various software and online tools that can convert PDF files to Excel. One example is Adobe Acrobat DC, which has a built-in export feature for Excel. Here are the steps:

  1. Open the PDF file in Adobe Acrobat DC.
  2. Click on “File” in the menu bar and then click “Export To”.
  3. Choose “Microsoft Excel Workbook” and then click “Export”.
  4. Choose the location where you want to save the Excel file and then click “Save”.
Baca Juga :  Cara Menghitung Interval Kelas Dengan Excel

How do I convert PowerPoint files to PDF?

Converting PowerPoint files to PDF can be useful for sharing the content with people who do not have PowerPoint installed. Here’s how to do it:

  1. Open the PowerPoint presentation that you want to convert to PDF.
  2. Click on “File” in the menu bar and then click “Save As”.
  3. Choose “PDF” from the “Save as type” dropdown menu and then click “Save”.
  4. Choose the location where you want to save the PDF file.

Video Tutorial

Check out this video tutorial for exporting Excel files to PDF and PowerPoint files to video: